Veeru
07-26-2017, 10:04 AM
Hi,
this is simple I guess for you guys but what I need is my code to find last empty row and then delete next 50 blank rows.
Like if my last empty row is A10 then code should take me to A11 and then delete empties rows from A11 till A61.
This looks crazy , why we want to delete empty rows but yes I need it for certain purposes.
below code is to find empty row. can anyone look into the same please
Sub test()
With Application.WorksheetFunction
Cells(.CountA(Columns("A:A")) + 1, 1).Select
End With
End Sub
this is simple I guess for you guys but what I need is my code to find last empty row and then delete next 50 blank rows.
Like if my last empty row is A10 then code should take me to A11 and then delete empties rows from A11 till A61.
This looks crazy , why we want to delete empty rows but yes I need it for certain purposes.
below code is to find empty row. can anyone look into the same please
Sub test()
With Application.WorksheetFunction
Cells(.CountA(Columns("A:A")) + 1, 1).Select
End With
End Sub