Macro to change all column headers to Uppercase (i.e. CAPITAL) letters.

Hi,

What I would like is a macro to search all my column headings i.e. column A through to column IV and change the text to all Uppercase (i.e. CAPITAL letters).

Any assistance in this matter would be greatly appreciated

Many thanks in advance


Rob

N.B. Excel version 2003

Enter this line in the immediate window within VBE

Please Login or Register  to view this content.

Hi,

Does this do it for you?

Please Login or Register  to view this content.

Andy & Sweep

many thanks for your prompt reply your code worked a treat

Thanks again

Rob