how to change cell format using vba
 

Hello All,

I would like to know how to change cell format using vba.

Please give me suggestion.


Thank you,

March

how to change cell format using vba
 

The macro recorder can be your friend. Record a macro while doing it. Then
clean it up if desired.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"March" wrote in message
...
Hello All,

I would like to know how to change cell format using vba.

Please give me suggestion.


Thank you,

March

how to change cell format using vba
 

You would use the NumberFormat property for the range of cells you want to
have the same format. See the help files for the NumberFormat Property for
some examples.

Rick


"March" wrote in message
...
Hello All,

I would like to know how to change cell format using vba.

Please give me suggestion.


Thank you,

March