Without seeing your code, can't be too specific, but something similar to
this should work. When you find the first instance of name, make a note of
xStart=ActiveCell.Row

Then, when you finish counting all the rows you want (I'll assume a variable
name of xCount)

Rows(xStart & ":" & xStart+xCount-1).Copy

This should select the rows your wanting.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JOSEPH WEBER" wrote:

I have a spreadsheet I am creating from a query ran in another program. I
have gotten pretty far in the macro programming as far as what i would like
to do. There is one part i can't figure out. I have the macro set up so it
looks for a value in sheet two to tell it which lines to copy, but i cant
figure out how to tell Excel to do it. for example, the data in column a is
a name, then all other lines in column a are blank for that particular
person. Once the macro comes across another name, i want it to select the
previous line all the way back up to the name, so i can get that whole
section. I have a counter set up so i can tell it how many lines to copy,
but just can't figure out how to tell Excel to do that.