Thread: removing blank cells

I had noticed this before and forgot to correct you on this.
You are installing the macro under Sheet1.
You should add a module and install it under module 1.
Look at the file I sent you.
Enter alt+F11, view the code. The macro is under module 1.
The short cut for the macro is ctrl+d.
modytrane.

thank you that works perfect.

If you are satisfied with the solution, please mark this thread "SOLVED".
modytrane