Hello,
I'm running a macro and this following code is giving me issues:
It work's fine except when there are no blank cells for it to delete it errors with the message "No blank cells were found". How do I communicate in VBA to ignore the error and continue with the rest of the macro?
Greemo
I'm running a macro and this following code is giving me issues:
Code:
Range("ImportDaily").SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp
It work's fine except when there are no blank cells for it to delete it errors with the message "No blank cells were found". How do I communicate in VBA to ignore the error and continue with the rest of the macro?
Greemo