Copy Data to external sheet with criteria
Excel vba 2010
I have code that copies data , but bascially all the data.
I need to only select data where "Column H" cells are blank, null or empty.
the amount of rows will always vary from project to project.
current code here:
Set curWks = ActiveSheet
With curWks
Set rngToCopy = .Range("A6:AU65453", .Range("A6").End(xlToRight
End With
Thanks
fordraiders
I have code that copies data , but bascially all the data.
I need to only select data where "Column H" cells are blank, null or empty.
the amount of rows will always vary from project to project.
current code here:
Set curWks = ActiveSheet
With curWks
Set rngToCopy = .Range("A6:AU65453", .Range("A6").End(xlToRight
End With
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Here's a special cells approach.
With curwks
Set rngToCopy = .Range("H1:H" & .Cells(Rows.Count, 8).End(xlUp).Row).SpecialCells(xlCellTypeBlanks)
End WithASKER
techfanatic, Will this copy all rows ?
starting in column a and going to A6:AU65453A6:AU65453
but only taking rows that are blank cells in column H ?
starting in column a and going to A6:AU65453A6:AU65453
but only taking rows that are blank cells in column H ?
ASKER
Thanks
excelfilterpaste.xlsm