"Myrna Larson" wrote in message
...
The statement you have searches from the bottom, up, for the last used
cell in the column. If
you have two blocks of data, and you want to work only with the first one,
you can try

Cells(1, 7).End(xlDown).Row


Actually, I had to change the Cells(1,7) to (10,7) since 10 was my first
populated row, but I see what you mean about the up and down etc, so this
will work for me I think on this particular excercise.

Thanks