Column Names 1

[Guest_imported]

Easy one for someone!

How do I change a column name say column A to Page, column B to Item etc...

Cheers,

Andrew Elliott

 

[bryanbayfield]

Hmmmm ... you can't!

All you can do is use column headings in your data table, ie put the names into row 1 of the table.

 

[ratman]

In line with Bryan's suggestion......this does it.

Sub colheads()
Sheets("Sheet1&quot.Activate
[A1].Value = "Part"
[B1].Value = "Ord."
[C1].Value = "Cust."
[D1].Value = "Loc."
[E1].Value = "Pcs."
ActiveWindow.DisplayHeadings = False
End Sub Thank you,
Dave Rattigan

 

[xlbo]

You could also go to Tools>Options>View and untick Row and Column headings
Then, you can fill the top row with your own headers and colour them grey

Be aware however that you won't be able to select full columns or rows without the headers so I'd suggest leaving it until last if you go down this route HTH
~Geoff~

 

[Guest_imported]

Cheers Guys,

I have tried the last one Geoff, but the trouble is we use the subtotal tool a lot and this method hides the 'global condensing' buttons.

I've tried your code thanks ratman, but yours does the same.

Any suggestions!

Thanks for trying to belittle me Bry - I hope your not a teacher - i be afraid to ask question in your class!

Any answer to my question - 'Userform, Module, Macro'?

 

[xlbo]

Sorry but Bryan is right - there's no way to customise the column headers except for getting rid of them but that seems like it isn't an option for you

ps - I don't think Bryan was trying to belittle you - just stating that what you were asking for, couldn't be done - there's not much more to say than that, ergo the short message

HTH
~Geoff~

 

[bryanbayfield]

I'm actually sympathetic to people's IT problems having been there myself, I was not having a pop at you.

As Geoff says, there was nothing more to say, so I didn't! Looks like you didn't take offence anyway thankfully.

For my money I'd never get rid of the column headings "A", "B", etc. It could lead to a lot of confusion when writing your code, and I don't think you lose that much by having the headings there.

Hope you got what you came for!

Bryan.