Vlad25
02-25-2014, 07:24 AM
Hello,
I would like to delete the last non-empty row on a worksheet - seems quite simple but I haven't managed to make it work !
Using the Record Macro function, I get this :
Sub Macro6()
Rows("63:63").Select
Selection.Delete Shift:=xlUp
End Sub
In my exemple, the row I want to delete is 63, so I'd need to replace it by the actual last row number...how can I do that ?
Thanks !
I would like to delete the last non-empty row on a worksheet - seems quite simple but I haven't managed to make it work !
Using the Record Macro function, I get this :
Sub Macro6()
Rows("63:63").Select
Selection.Delete Shift:=xlUp
End Sub
In my exemple, the row I want to delete is 63, so I'd need to replace it by the actual last row number...how can I do that ?
Thanks !