Capitalize all Entries in a Column

Hi all,
I have a spreadsheet that contains a huge amount of data.
I need a Macro (Not the UPPER formula please) to capitalize Columns T, AA and AB (all the way to the last row) with a press of the Capitalize button.
I have attached a dummy spreadsheet. Hope you can help me.

Thank you.

Hi Andrew,

Not sure why you don't want to use the UPPER function (even in a macro), but here's how you can do it:

Please Login or Register  to view this content.

Regards,

Robert

Please Login or Register  to view this content.

I decided to use this:

Please Login or Register  to view this content.

Another question, if the entry on cell is already capitalized, is there a way to skip it? Right now I'm getting error when I try to run the codes.
It appears that it's because some entries are already capitalized.

I'm getting Type mismatch error on this line --> Range("AB" & i) = UCase(Range("AB" & i))

Originally Posted by Andrew.Trevayne

Another question, if the entry on cell is already capitalized, is there a way to skip it? Right now I'm getting error when I try to run the codes.
It appears that it's because some entries are already capitalized.

I'm getting Type mismatch error on this line --> Range("AB" & i) = UCase(Range("AB" & i))

Hi,

That would not occur due to text already being in capitals. It will occur if you have any error values in the cells.