Hi Guys,


I need a copy and paste function, where the copied cells are checked for blank rows. Any blank rows are deleted.

EG, if row 2 was blank, row 3 would because the new row 2, row 4 would become the new row 3, repeated until all the blank rows were removed.

should work for any size range copied.


Thanks guys,

Jimmy