Format an entire sheet to be 'General' cells

[jnagel]

Hello,

Is there a line in VBA I can add to ensure that the formatting of every cell in a worksheet is 'General'?

Thanks in advance for your help

 

[Rick Rothstein]

If you are formatting the ActiveSheet, you can use this line of code...

Cells.NumberFormat="General"

If you want to format a sheet that is not necessarily going to be the ActiveSheet (let's assume it is going to be Sheet2), then use this instead...

Worksheets("Sheet2").Cells.NumberFormat="General"

 

[Sektor]

[COLOR="Blue"]Sub[/COLOR] AllGeneral()
    Cells.NumberFormat = "General"
[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[jnagel]

Perfect!

Many thanks