|
Posted to microsoft.public.excel.programming
|
|
|
last used row.
Have a look here
http://www.mvps.org/dmcritchie/excel/lastcell.htm
Mike
"sunilpatel" wrote:
Hi
I have several sheets which are populated by macro's, using copy and paste.
i have found that with some sheets the scroll bar on left is small i.e Excel
thinks, the last row used is very high. e.g 6000
But the last row actually used is only 500 for example not 6000. This makes
my workbook size larger than necessary.
Is there a way to find the actual last row used i.e first blank cell in
coulmn A for each sheet and reset what Excell thinks is the last row. Hope i
am making sense !
Sunil
|