copy sheet to another

I have a sheet that contains imported data and need to copy it to another sheet complete just copy and paste. However if someone changes the column size an error indicating different shape is received.

I have this code and figure there has to be a better way

Sheets("ImportData").Select
ActiveSheet.Cells.Select
Selection.Copy
Sheets("RawData").Select
ActiveSheet.Paste

I would have imported this directly to the Rawdata sheet however other sheets have formula dependancies.

Thanks

Wayne

A faster way... You can change Destination Cell with any kind of range...


Sheets("ImportData").Cells.Copy Sheets("RawData").Cells

Great stuff Jamirez, thanks!!

Wayne