After serious thinking mp wrote :
given sheet with data on x rows
then x rows blank
then x rows data
then x rows blank
etc

is there an easy way to jump from data group to data group?
or just increment a counter and check each row(some cell in row) for .value =
"" ?

thanks
mark

Check out using the End() method with Range/Cells/Selection/ActiveCell
objects, and compare how it works with using the keyboard combo of
holding down Ctrl while pressing one of the Arrow keys.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion