I'm getting a VBA error (
Run-time error '9': Subscript out of range) when I am trying to select a workbook and then a cell within a sheet in that workbook.
this_workbook is correct, and copying and pasting the output into Windows
Run results in the workbook opening.
data_worksheet is also correct.
this_workbook = ThisWorkbook.Path & "\" & ThisWorkbook.Name Debug.Print "Workbook name - " & this_workbook & vbCrLf Workbooks(this_workbook).Sheets(data_worksheet).Range("A1").Select
Anybody know what I am doing wrong?