Change the header name of a column

[AT76]

I have an .xls spreadsheet and in row 1 of the spreadsheet I would like to change random header names. Is there a way to do this using:

xlws.Columns

Thank you!

 

[PHV]

I'd use xlws.Cells(1, colNumber) = "NewColName"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AT76]

I found the answer:

xlws.Cells(1, "Letter of Column") = "New Header Name