Ravi,

Thanks for the reply. The code worked like a charm but with a slight glitch

The cells D9 - BX9 are being copied and pasted to a new sheet,
but instead of being pasted into the same row, one after the other, they are being posted on different rows. What I want is something like,

The first 73 cells copied from D9 - BX9 get pasted from D2 - D74 of the new sheet and D10 - BX10 get pasted on D75- D147 and so on.

Regards

Wahaj