formatting a column w/ macro, when top row is merged

[graphage]

My top row is merged (10 columns together). I wrote a macro to format a column as a percentage:

Columns("C:C").Select
Selection.NumberFormat = "0%"

Manually, it works fine to click on the column heading and format it. But by doing it via macro, since the top row is merged it changed ALL of my number columns to a percentage. How do I get around this?? thanks!!

 

[Barrie Davidson]

On 2002-03-08 12:50, graphage wrote:
My top row is merged (10 columns together). I wrote a macro to format a column as a percentage:

Columns("C:C").Select
Selection.NumberFormat = "0%"

Manually, it works fine to click on the column heading and format it. But by doing it via macro, since the top row is merged it changed ALL of my number columns to a percentage. How do I get around this?? thanks!!

Try

Columns("C:C").NumberFormat = "0%"