View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Loop for myRng for next set of 9 rows

Hi Garry,

Am Tue, 16 Jun 2015 03:51:22 -0400 schrieb GS:

..but I didn't see the need for using CountA since we're looping from
start row to last row of data.


only for the case that one of the blocks has no values. Otherwise you
get a blank row.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional