Macro to delete entirely blank row in range

[Coop91]

Hey guys,
I'm pretty new to using macros, but I've been trying to work on one to delete completely blank rows from row 108 to the end of the data. Ideally, I then want to copy the remaining cells and paste them in row 66. Would anyone be able to help me out? I'm struggling a little bit.

Cheers,
Coop

 

[Coop91]

.

 

[Marcelo Branco]

Hi,

Maybe this can help

http://www.ozgrid.com/VBA/VBACode.htm

M.

 

[Coop91]

That seems to work, thanks!!

Any idea about the copy/paste?

 

[Marcelo Branco]

Take a look at

http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm

in the topic

Avoid the use of Copy and Paste whenever Possible

M.