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..??
- Jan 09, 2022
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".
OliverScheurich
Jan 09, 2022Gold 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".
Excel
Jan 09, 2022Iron Contributor
It works.
Thank you so much sir.
Thank you so much sir.