Link Filter
 

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.

--
Ray Tweedale

Link Filter
 

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)?

--
Ray Tweedale


"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"Tweedy" wrote:

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.

--
Ray Tweedale