| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to show blank instead of 0 when there is no value in linked cell?
Sometimes, a cell is blank whose contents are being linked to in
another sheet in a workbook. When that is the case, instead of 0, what can we put in the code to just show a blank as well in the second sheet? Right now, if the cell is blank, the link cell shows a "0". Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need linked cell to be blank not 0 | Excel Discussion (Misc queries) | |||
| Show linked cell alone somwhere on the desktop | New Users to Excel | |||
| Return a blank cell instead of a zero value for two linked sheets. | Excel Discussion (Misc queries) | |||
| How do I show the VALUE in a linked cell? | Excel Worksheet Functions | |||
| linked cell doesn't show formatting | Excel Worksheet Functions | |||
![StargateFan[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
