Hi Pros, can anyone please help me with this?
I was using VBA to do some copy & paste, this time I got a error because the target range has no data/value, and gives me a run-time error 1004: No cells were found.
In most of time these cells have value, as it's pasted from a raw data sheet which is updated on a daily basis, therefore I still want to keep these lines, just wondering is there a code to skip this error so that this macro can keep running? Thanks heaps!
Any thoughts would be appreciated!
I was using VBA to do some copy & paste, this time I got a error because the target range has no data/value, and gives me a run-time error 1004: No cells were found.
In most of time these cells have value, as it's pasted from a raw data sheet which is updated on a daily basis, therefore I still want to keep these lines, just wondering is there a code to skip this error so that this macro can keep running? Thanks heaps!
Code:
ws1.Select
ActiveSheet.Range("A1:G" & LROW).AutoFilter Field:=7, Criteria1:= _
"NOVATED LEASE"
[B]Range("A3:G" & LROW).SpecialCells(xlCellTypeVisible).Copy[/B] ---> ERROR
Sheets("Novated").Select
Range("A4").Select
ActiveSheet.Paste
Any thoughts would be appreciated!