Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
last used row.
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 |