paultje_bos
New Member
- Joined
- Oct 20, 2014
- Messages
- 39
Hi,
I have a sheet with formulas that leaves the cell blank when the result is null (iferror). But when I copy the cells (including blank cells with a formula) and I paste them as value, the empty cells will still be selected when I use ctrl+shift+down. But if I click on the empty cell there is nothing in there, not even the formula (because I pasted it as value).
For some reason Excel still "see" something in the cell.
Reason I ask is because I have a macro that selects data from one sheet (including blank cells with formula), copy and paste them on a different sheet on the first empty row. But the next time I run the marco, the first empty row is not the real empty row because of the problem I mentioned above.
Hope I make some clear. If somebody would have an anwser or work around for me, that would be great.
I have a sheet with formulas that leaves the cell blank when the result is null (iferror). But when I copy the cells (including blank cells with a formula) and I paste them as value, the empty cells will still be selected when I use ctrl+shift+down. But if I click on the empty cell there is nothing in there, not even the formula (because I pasted it as value).
For some reason Excel still "see" something in the cell.
Reason I ask is because I have a macro that selects data from one sheet (including blank cells with formula), copy and paste them on a different sheet on the first empty row. But the next time I run the marco, the first empty row is not the real empty row because of the problem I mentioned above.
Hope I make some clear. If somebody would have an anwser or work around for me, that would be great.