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.
Yes, I agree in general. In the case of wanting to know where empty
blocks occur, I prefer to see the blank rows. For example, data dumped
from a data recorder that may contain blank records for any number of
reasons that indicate some troubleshooting is needed.
I included CountA in my original reply instinctively, but gave it a 2nd
thought during sub2.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion