C
Chris Watts
I have a worksheet where I have deleted the data form the last batch of rows
and wish to reset (using VBA) the last row used returned by Excel 2007 to
the genuinely occuped rows.
I have tried using: ActiveSheet.UsedRange but it doesn't do the trick.
That is probably because the rows from which I have deleted the data have
still retained their formatting. I do want to retain the formatting (eg row
height etc) as I wish to add further data in due course.
Any suggestions as to how I can reset what Excel returns as last row used in
these circumstances?
TIA
Chris
and wish to reset (using VBA) the last row used returned by Excel 2007 to
the genuinely occuped rows.
I have tried using: ActiveSheet.UsedRange but it doesn't do the trick.
That is probably because the rows from which I have deleted the data have
still retained their formatting. I do want to retain the formatting (eg row
height etc) as I wish to add further data in due course.
Any suggestions as to how I can reset what Excel returns as last row used in
these circumstances?
TIA
Chris