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
|