how to change cell format using vba

M

March

Hello All,

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

Please give me suggestion.


Thank you,

March
 
D

Don Guillett

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

Rick Rothstein \(MVP - VB\)

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
 
Top