Adding used ranges from various sheets to one sheet

[JohnnyBGood]

Hi,

I want to copy (values/formats only) each used range from Sheet2 to Sheet10 onto Sheet1 starting at A1.

Can anyone help with a VBA Code

Thanks for any help.

[StephenR]

UNTESTED

Please Login or Register  to view this content.

[JohnnyBGood]

Thanks Stephen,

That worked great (and fast too).

Is it possible to do this but exclude the copying of row 1 from each sheet (i.e. the column titles don't need to be copied over).

[StephenR]

Good. Try this, also untested

Please Login or Register  to view this content.

[JohnnyBGood]

That's great!

Thanks very much.