Solved: finding last row w/ (xldown)

[YellowLabPro]

I use .end(xlup) all the time.
This time I wanted to use (xldown).

The last row of data is in row 8.

This line tells me that the last row is 65,536, not 8. Is this correct? What property should I use to find row 8 going down?
[VBA]
lrow = Cells(Rows.Count, 1).End(xlDown).Row
[/VBA]

[Gert Jan]

When using Rows.count you start at the bottom, going down leaves you at the bottom, so lrow is always 65536.

You could try
[VBA]lrow = Cells(1, 1).End(xlDown).Row [/VBA]

[YellowLabPro]

Thanks Gert,
works fine.
But let me clarfy your point.
You are saying count starts at the bottom of the sheet, not at the top?

[Gert Jan]

Try this one out

[VBA]Sub test()
Dim lrow As Long
lrow = Cells(Rows.Count, 1).Row
MsgBox lrow
End Sub[/VBA]

[Bob Phillips]

NO, he is saying that if you set the start row to Rows.Count, then it will start at the bottom of the sheet.

[Gert Jan]

NO, he is saying that if you set the start row to Rows.Count, then it will start at the bottom of the sheet.

Thanks for explaining, i should have been a bit more complete in my reply.

Gert Jan

[YellowLabPro]

Subtle differences.... spices of life....

thanks Gert and Bob