Set wSh = sheets("myCodeName")
"Nigel" wrote:
Hi All
I have the codenames for various worksheets stored as strings in another
worksheet. How can I assign each sheet to an object?
e.g. If I have the string "myCodeName" which is the codename for one of the
worksheets, and want to assign it to a worksheet object
Dim wSh as Worksheet
Set wSh = ??
TIA
--
Regards,
Nigel