C
Colin Hayes
Hi All
After running my macro , I need to delete a number of rows from the end
of the worksheet.
I use the variable lrow to find the last row.
To delete the 20 rows below the last row , I'm trying this :
Rows("lrow+1:lrow+20").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
It's not working , and gives errors. Can someone advise on a code that
would work?
Grateful for any advice.
After running my macro , I need to delete a number of rows from the end
of the worksheet.
I use the variable lrow to find the last row.
To delete the 20 rows below the last row , I'm trying this :
Rows("lrow+1:lrow+20").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
It's not working , and gives errors. Can someone advise on a code that
would work?
Grateful for any advice.