Formating a Cell
Range("A1").Font.Size = 12
Range("A1").Font.ColorIndex = 3 'this is red
Range("A1").Font.Bold = True
But the easiest way is to record a macro while doing such operations on the
spreadsheat.
Regards,
Stefi
€ždnzone€ť ezt Ă*rta:
Can anyone teach me how I can change the font size/font color/bold on certain
cell in a excel worksheet using vba
|