correct syntax to assign a range from one worksheet to another worksheet?

[Andrew Entee]

What's the correct syntax to assign a range from one worksheet to another worksheet?
i.e. I'm trying to have a New worksheet from A1:Z10 contain the rows from Another worksheet from A20:Z30

I tried this - but I'm missing something

Set Newsheet = AnotherSheet.Range("A20:Z30")

Thanks

[stnkynts]

There are multiple ways to do this. Here is one (assuming sheets are named Sheet1 (output) and Sheet2 (source)):

Please Login or Register  to view this content.

[Andrew Entee]

Awesome - thanks