Forum Discussion
Excel
Jan 09, 2022Iron Contributor
VBA
Hello Everyone,
How to show header in different columns with the help of VBA code?
like :
Please help..??
Sub Add_headers()
With Sheets("Tabelle1")
.Range("A1:E1").Value = Array("Region", "Expenses", "January", "February", "March")
End With
End Sub
Maybe with above code if sheetname is "Tabelle1".
2 Replies
- OliverScheurichGold Contributor
Sub Add_headers()
With Sheets("Tabelle1")
.Range("A1:E1").Value = Array("Region", "Expenses", "January", "February", "March")
End With
End Sub
Maybe with above code if sheetname is "Tabelle1".
- ExcelIron ContributorIt works.
Thank you so much sir.