I want to get rid of the empty rows that my ERP quotation produces. I'm trying to go through the entire document (A1:Z50) and eliminate any rows where the cells are empty (A1-B1...Z1 = empty, A5-B5...Z5 = empty).
I found this, but can't seem to configure it for me.
On Error Resume Next
On Error GoTo 0