View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default Loop for myRng for next set of 9 rows

Hi Garry and Claus,

I tried Garry's revised code and Claus' first code on 6000 rows. Returns 600 rows.

Both are spot on and under 1 second, (mental clock).

Thank you both, appreciate it.