If you want to refer to the currently selected worksheet in a workbook, you can do so by using 

the ActiveSheet property. For example, the subroutine below will enter the value 100 into 

cell A1 in Worksheets(2) as the current selected worksheet.

Sub ActiveSheetDemo ( )

ActiveSheet.Cells(1,1).Value = 100

End Sub.