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:
=IF('[Book2.xls]Wk 1'!K25="","",'[Book2.xls]Wk 1'!K25)
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
Bookmarks