How to open a worksheet using its defined variable

Question

I am trying to open a worksheet that is a defined variable. I have a list of ID's and each of those ID's have their own worksheet where the name of the worksheet is the ID number. I am wanting to use the first ID value and assign it to a variable, then open the corresponding worksheet using that variable. Here is the current code I have. The error message is "Object Required".

 Dim proj As Range Dim Project As Range Set proj = Sheets("Project List").Range("B9") Set Project = proj.Value Sheets(Project).Activate

mechanical_meat · Accepted Answer · 2016-07-08 16:34:33Z

You are trying to put a value into an object. Also you should probably specify the workbook. Try instead:

Dim proj As Range Dim Project As String Set proj = ActiveWorkbook.Sheets("Project List").Range("B9") Project = proj.Value ActiveWorkbook.Sheets(Project).Activate

davidhu · Accepted Answer · 2016-07-08 16:39:22Z

you just need to convert the range into a string, which is what the argument needs to be for Sheets()

Dim proj As Range Set proj = Worksheets("Project List").Range("B9") Sheets(proj.Text).Activate

Collectives™ on Stack Overflow

How to open a worksheet using its defined variable

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related