grexcelman
Board Regular
- Joined
- Mar 1, 2015
- Messages
- 50
Can someone tell me the syntax for writing the following when I have the name of the sheet in a cell value?
The following works for me:
I'd like to be able to change the name of the worksheet so I can apply the remaining code regardless of the sheet name, I have roughly 12 sheets with data with the name of each sheet in cell B1. I can't seem to get the value into the above function.
Any suggestions?
The following works for me:
Code:
Dim ws as worksheet
Set ws = ThisWorkbook.Worksheets("Systems")
Any suggestions?