Macro To Replace Cell Link With If Statement To Hide Zeros

[CVinje]

I'm working on a sheet that has links to another workbook with some cells that will be empty at times, thus a zero is displayed in the linked cell. I understand that I can keep that zero from being displayed by modifying the link with an IF statement as follows:

Please Login or Register  to view this content.

What I'd like to do is have a macro that will automatically look for cell links that do not have this IF statement wrapping them and add it. Any other alternative (using macro for find/replace with wildcards??, etc.).

Any help will be greatly appreciated,

CVinje

[DonkeyOte]

Is 0 ever a valid value ?

If not rather than double evaluating all the links I would advise using a Custom Format on the relevant sections so as to hide the 0's.

[CVinje]

Yes, on some columns in the sheet, the value of Zero is preferred; however, if there is no easy solution to this problem, I could resort to un-checking the show zero box under the options, but I'd like to avoid that if possible.

**Edited to add: Or, instead of un-checking that box, implementing the custom format on the selected cells (0;-0;;@) as you stated. That may be a viable solution, and I will begin looking at that now.

Thanks,

CVinje

[CVinje]

After reviewing the option to use Custom Format to not show the zero value in certain cells I've determined that if there is anyway possible to accomplish this without using the custom format, it would definitely be preferable. In some instances, the value of zero is desired to be displayed in these cells (if the value of zero is displayed in the cell(s) linked to).

Thanks,

CVinje