Thread: Link Filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tweedy Tweedy is offline
external usenet poster
 
Posts: 14
Default 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