I have done in the past

do while (cell(row + 1,column).value = "") and cell(row + 2,column).value =
"")

" wrote:

On Feb 17, 12:47 pm, Joel wrote:
The focus may be changing. When you copy the code the focus may be on one
worksheet. Then the sort is changing the focus to another worksheet. The
past is going to where the last focus ends up. You probably just have to
activate the correct worksheet before you do the paste

Works great, thanks. Just had to copy after activating and inserting a
row on the other worksheet.

I continue to fight this sorting problem, seems like everyone that
wants to sort a sheet with blank rows is in the same boat. So how
about this; can I find only the blank rows and number them? I would
have to do this from the top down and number the blanks sequentially,
then when it reaches the end of the sheet data stop when it sees 2
blank rows. I received great advice from Tom on how to search from the
bottom up and insert new rows with data and a blank row in-between, so
if I can get the sort down I should be set.

Thanks,

Chad