In VBA, one normally refers to a worksheet by the name 'Sheet 1' with the code
Code:
Worksheets("Sheet 1")