ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will do this for you nicely...........

hth
Vaya con Dios,
Chuck, CABGx3



"Robert11" wrote:

Hello:

I have a sheet with lots of blank rows.

Is there any way to compact things, and remove the blank rows all in one
shot ?

Thanks,
Bob