VBA

[Excel]

Hello Everyone,

How to show header in different columns with the help of VBA code?

like :

Please help..??

[#2 · Accepted solution]

@Excel 

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".

[#3]

It works.
Thank you so much sir.