Accessing worksheets: error 9: subscript out of range

Hi everyone,
This is my first VBA project so any help is appreciated! The following code is the beginning of a function I am writing to save a spreadsheet to file. When I include the fourth line (saveFolder = ...), I get error '9': subscript out of range. I am trying to access the worksheet because it has the folder location I plan to save the file to. How can I fix this? Thanks!!


Private Sub btnExport_Click()
Workbooks("Timesheet Userform.xlsm").Activate
Worksheets("Timesheet").Activate
saveFolder = Worksheets("Timesheets").Cells(2, 2)
ActiveSheet.Copy
...
...

It might be trying to get something OTHER than the value in the cell, so make sure of it...
saveFolder = Worksheets("Timesheets").Cells(2, 2).value

it could also be the subscript of the worksheets is out of range. (no sheet called "Timesheets").

Oh thanks , that was silly.
So I'm back to my old problem. The error is gone but nothing gets saved to the variable even though the cell has data

Okay, problem solved now. Thanks everyone