View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default surpress zero-values in specifi columns (not complete workbook/window)

If they are produced by formulas

=if(formula=0,"",formula)

--
Regards,
Tom Ogilvy

"nortor" wrote in message
...
Hello!

Help needed - again :-)

I need to surpress all zero values in a few selected columns.
How do I solve this by VBA-code please?


Best regards,
-NorTor