Paste Special - Values Query
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 |
Paste Special - Values Query
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 |
All times are GMT +1. The time now is 03:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com