excel hide zeros code example

Example: excel vba hide zero values

' Excel
CTRL+1 > Format Cells > Number > Custom > 0;-0;;@
' VBA
ActiveWindow.DisplayZeros = False