I can't seem to figure out what is wrong with this line of code, I get a multitude of errors depending on what changes I make. The one I am getting with this specific syntax is "Select method of range class global failed"
Worksheets("" & hydraulics.actoggle.Value).Range("B65536").Select
When I move the mouse over the hydraulics.actoggle.Value it shows that the value is "Toggle 2" which is the name of the worksheet I am trying to get to. Any help would be appreciated.
Thanks,
Chris
Worksheets("" & hydraulics.actoggle.Value).Range("B65536").Select
When I move the mouse over the hydraulics.actoggle.Value it shows that the value is "Toggle 2" which is the name of the worksheet I am trying to get to. Any help would be appreciated.
Thanks,
Chris