G
Guest
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.
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.