| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
surpress zero-values in specifi columns (not complete workbook/window)
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
surpress zero-values in specifi columns (not complete workbook/window)
You can use Conditional formatting, NorTor. It's under the Format menu.
If the cell value = 0, turn the font white. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
surpress zero-values in specifi columns (not complete workbook/window)
Tom and Anne;
thank you both for your replies. I will do it one of your suggested ways. I guess that must be the best ways, as there is no way to it for just a selected range another more 'direct' way. Thanks again! :-) Regards, -NorTor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Surpress Average Error | New Users to Excel | |||
| Complete path info on Excel window | Excel Discussion (Misc queries) | |||
| saving a file based on a value in predertermined cell to a specifi | Excel Discussion (Misc queries) | |||
| same date and set up on complete workbook | New Users to Excel | |||
| Excel will not allow me to change a numerical figure in a specifi. | Excel Discussion (Misc queries) | |||
Hybrid Mode
