Hi,
How can I retrieve the last row in a specified colum that full with
information?

I tried to use in Sheet2.Cells.SpecialCells(xlLastCell).Row
but in big numbers it flew.
thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Hi Efi,

"Sheet2.Cells.SpecialCells(xlLastCell).Row"
This will give you the last row irrespective of column. As you asked,
you need to find out last row of a particular column that filled with
data. Try following but, some function should be there to minimize the
code.

Dim i As Integer

i=1

While ActiveSheet.Rows.Cells(i, 1).Value < "" '## here 1
represents column "A" ##'
i = i + 1
Wend
MsgBox i - 1

Nilopher.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/