Excel, Null

[Nitha120]

Hi is there away to delete the result of "0" as blank?

I am doing a calculation for multiple worksheet i some range are between 1-25 other 1-30, I want a code to look at my range if it equal to Zero (0) just ignore the cell dont display the Zero.

any suggestion guys?

 

[PHV]

Why not simply playing with the Cell's format ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Zathras]

Tools / Options / View tab: Remove the check mark by "Zero values"

or if you want code:
[tt]
ActiveWindow.DisplayZeros = False
[/tt]