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

graphage · Mar 8th, 2002, 01:50 PM

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 · Mar 8th, 2002, 01:57 PM

Quote:

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%"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 01:50 PM	#1
graphage Board Regular Join Date: Mar 2002 Posts: 69	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!!