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