How to format column 7 ?
 

In VBA, if I have the integer 7, how do I format column 7?

The recorder does

Columns("G:G").Select
Selection.Numberformat = "blah"

Thanks.

How to format column 7 ?
 

Columns(7).NumberFormat = "#.00.00"

--


Gary


wrote in message
ups.com...
In VBA, if I have the integer 7, how do I format column 7?

The recorder does

Columns("G:G").Select
Selection.Numberformat = "blah"

Thanks.

How to format column 7 ?
 

Columns(7).Select
Selection.NumberFormat = "#.0"
or
Columns(7).NumberFormat="#.0"
James

wrote:
In VBA, if I have the integer 7, how do I format column 7?

The recorder does

Columns("G:G").Select
Selection.Numberformat = "blah"

Thanks.

How to format column 7 ?
 

Myinteger = 7
Columns(Myinteger).Select
Selection.NumberFormat = "Blah"

wrote:
In VBA, if I have the integer 7, how do I format column 7?

The recorder does

Columns("G:G").Select
Selection.Numberformat = "blah"

Thanks.