WorkSheets("Mary").Range....
WorkSheet(3).Range... or
Sheet3.Range...
'refer to sheets via CodeName:
Sheet2.Range("A2:A10").Formula = "=RAND()"
'text in red above is the code name (as determined from the properties window of the worksheet in question)