Quick .End(xlUp) Question
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
|