Referring to cells on other worksheet in VB?

[ikkenenderikke]

Simple question with a probably very simple answer:

I want to sort values on an other worksheet then the one i'm writing the code in. Now I have:

Set Rng = Range("A2:C21")

but "A2:C21" refers to the cells on the same page. I want to refer to an other worksheet in my document.

e.g. "Paper1!A2:C21"
That's how it works in Excel, but in VB it won't work.

Thanks already!

[Asala42]

Set Rng = WorkSheets("Paper1").Range("A2:C21")

[ikkenenderikke]

Thank you very much!!!