Link Filter

[Guest]

Hello All,

I am linking data to a worksheet that has some values equating to 0 because
the source cell is empty. Search and Replace for a 0 doesn't work because it
finds the formula which is not a 0.
Any help on how I can replace the 0 with a NULL via a macro in a selection
from A1 thru R110? I'm using Excel 2002.

 

[Guest]

change your formula to

=if(Z20="",na(),Z20)

then select all the cells and do Edit=>goto=>special, select formulas and
errors. Do edit=>delete

 

[Guest]

Ok. I see what that does and do frequently use the IF(Undesired value, Then
do NULL, ELSE Desired Value) and it's a cute trick using the GOTO SPECIAL
feature to rid them but how can I easily change all 1980 of the formulas
(links)?