How do I reset the LastUsed cell reference from code.

  • Thread starter Thread starter Henry
  • Start date Start date
H

Henry

I've a shared workbook and need to print a report from it.
I've set a sheet up with 2 header rows.
For each row of data I insert a new row 3 and copy the data to be printed to
it.
When all the data has been transferred I sort the sheet and set the print
range as
"A1:K" & LastUsed.Rows(Count)
I print the sheet and delete the data.
The more the sheet is used, the more I get 1 or 2 sheets with data on them
and more and more blank sheets.
Also, as the sheet size is increasing each time, the workbook takes longer
and longer to load and save.
As it's in a shared file, XL will not allow deletion of the sheet.

So, I need to know how to reset the LastUsed Cell to (say) K3
or if there is another way around this problem.
(There's usually another way any problem, the problem is knowing it!)

TIA
Henry
 
Back
Top