

To select cell F7 on another worksheet (Sheet3) in the same workbook, you can use either of the following examples:
Application.Goto ActiveWorkbook.Sheets("Sheet3").Cells(7, 6)
-or-
Application.Goto (ActiveWorkbook.Sheets("Sheet3").Range("F7"))
You can also activate the worksheet, and then use method 1 above to select the cell:
Sheets("Sheet3").Activate
ActiveSheet.Cells(7, 6).Select
ActiveSheet.Cells(7, 6).Select