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

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.

--
Regards,
Tom Ogilvy



"Dan R." wrote:

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

Thanks Tom, I'll use that.

Dan