Search code examples
excelvbashowzero

Create new worksheets using VBA not showing the zero values

If a worksheet does not exist, I create a new worksheet wit the command

Sheets.Add After:=Sheets(Sheets.count).

I don't want to see the zero values in these sheets but don't know how to do this in VBA. I want to do this with a VBA instruction.

Solution

  • You can use this to show zeros as blanks.

    ActiveWindow.DisplayZeros = False