ExcelBanter - Formating a Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formating a Cell (https://www.excelbanter.com/excel-programming/373970-formating-cell.html)

dnzone

Formating a Cell

Can anyone teach me how I can change the font size/font color/bold on certain
cell in a excel worksheet using vba

Stefi

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

All times are GMT +1. The time now is 06:48 AM.