Trapping the last row

[Guest]

Dear All

Kindly help me with this. I have lots of sheets and lots of data in each of the sheet. I need to pick up the information from each of the sheets for consolidation. For this I need to trap the last row in each of the sheets. If anyone has the code to trap the number of the last row kindly send me at the earliest

Regard
AC

 

[Rob van Gelder]

"Last Row/Col in Worksheet" is available on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel

Dear All,

Kindly help me with this. I have lots of sheets and lots of data in each

of the sheet. I need to pick up the information from each of the sheets for
consolidation. For this I need to trap the last row in each of the sheets.
If anyone has the code to trap the number of the last row kindly send me at
the earliest.

 

[Bob Phillips]

AC,

You can find the last row with

cLastRow = Activesheet.Cells(Rows.Count,"A").End(xlUp).Row

Change column A to suiit the appropriate column for your workbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Dear All,

Kindly help me with this. I have lots of sheets and lots of data in each

of the sheet. I need to pick up the information from each of the sheets for
consolidation. For this I need to trap the last row in each of the sheets.
If anyone has the code to trap the number of the last row kindly send me at
the earliest.