Hi I am getting a runtime error: subscript out of range.
Here is the code where the error occurs:

Set ortsheet = xlOrt.Workbooks(1).Sheets(Productname)

Productname is the string returned from an Input box for the sheet name. I made sure the syntax of the sheet name was correct.
Isn't this the way to return a specific worksheet object? I only have 1 workbook opened, which has multiple worksheets.