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

When you put a formula in the cell, the cell is not empty.

If I'm going to convert to values after I apply that kind of formula, I use
something like:

=IF('Site F2R Sheet'!B7="",na(),'Site F2R Sheet'!$B$3)

Then after I edit|copy, edit|paste special values, I just do one more
edit|replace to change the #n/a's to nothing (leave it blank).

Dean wrote:

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

--

Dave Peterson