View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan R. Dan R. is offline
external usenet poster
 
Posts: 220
Default 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