surfengine
New Member
- Joined
- Jan 29, 2021
- Messages
- 5
- Office Version
- 2019
- Platform
- Windows
Not sure how to handle this issue in VB.
I copy all data from a sheet and paste it to a new sheet where the data will be manipulated. One of the cells has a formula that puts a blank, ex: =if(a1=1,1,"")
When that row is copied over it is blank but excel still sees that something is there and my next step which is to remove all rows that have a blank cell in that column doesn't remove any rows.
I know this is an old issue and there are many posts about it everywhere, but none of the solutions I have seen so far help resolve my exact case.
This is my copy/paste code:
I copy all data from a sheet and paste it to a new sheet where the data will be manipulated. One of the cells has a formula that puts a blank, ex: =if(a1=1,1,"")
When that row is copied over it is blank but excel still sees that something is there and my next step which is to remove all rows that have a blank cell in that column doesn't remove any rows.
I know this is an old issue and there are many posts about it everywhere, but none of the solutions I have seen so far help resolve my exact case.
This is my copy/paste code:
VBA Code:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Rows("1:1").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp