last used row.

[sunilpatel]

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

 

[Mike H]

Have a look here

http://www.mvps.org/dmcritchie/excel/lastcell.htm

Mike

 

[Gord Dibben]

Use debra Dalgleish's reset all worksheets' usedrange code.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

 

[ward376]

Ron Debruin has examples of using a function to return the last row
number that contains data:
http://www.rondebruin.nl/tips.htm

Cliff Edwards