VBA code to copy selected Cells from one sheet to another without changing the format

[sierra_stone]

I want the VBA script that copies Values from one sheet to another with same format

E.g Copy the Range N21:P35 from Sheet1 to Sheet2 to Range B2:D:36
Copy Range T21:V:35 from Sheet1 to Sheet2 H2:J36
Copy Range N40:P54 from Sheet1 to Sheet2 B41:D55 and so there are multiple such data and multiple range, Number of cells in Range is same for all.
However I do not want the unwanted cells to be copied,

[Richard Buttrey]

Hi,

Please clarify.

You say you want to copy N21:P35 (i.e. 15 rows) to B2:D36 (i.e. 35 rows). How do you expect to fit 15 rows into 35 rows. Ditto with T21:V35.

How many sets of ranges are there?

What do you mean by you don't want unwanted cells to be copied. How are you defining 'unwanted'?