Good point, thanks Gord. I have the Del_Empty_Rows() macro on a
toolbar so it's just a button click away, but it's good to remember
the non-macro version.

I also read your post about copy and pasting cells as links, same
response :)

--JP


On Jan 11, 4:43*pm, Gord Dibben <gorddibbATshawDOTca wrote:
JP

After paste special, you could also select the column and F5SpecialBlanksOK

EditDeleteEntire Rows.

Gord Dibben *MS Excel MVP