I have nested formula (IF statements) in a number of Rows (3 to 250). The
cells containing the formula remain blank unless data on another sheet is
populated
(=IF('Site F2R Sheet'!B7="","",'Site F2R Sheet'!$B$3)
I want to run a macro that will highlight only those cells that contain
information but when I use Cntrl, Shft + down arrow it is selecting rows 3 to
250.
Alternatively if this is not possible how can I Paste (Special - Values)
only the data picked up by the formaula and not the blank cells that contain
the IF statements.
Thanks.
--
Dean Pery