Quick .End(xlUp) Question

[Dan R.]

If I know my data won't exceed 7 or 8 thousand rows, should I use
this?
iEnd = ws.Cells(10000, 9).End(xlUp).Row

Rather than this?
iEnd = ws.Cells(65536, 9).End(xlUp).Row

Or does it really not make much of a difference (speedwise)?

Thanks,
-- Dan

 

[Guest]

iEnd = ws.Cells(rows.count,9).End(xlup).row

I don't know the inner workings of Excel, but I don't think there is an
appreciable difference from a practical standpoint.

 

[Dan R.]

Thanks Tom, I'll use that.

Dan