Setting aws to name stored in an array
I have the following:
For iCtr = LBound(myWSNames) To UBound(myWSNames)
Set aWS = Nothing
Set aWS = Sheets(myWSNames(iCtr))
if aws is not nothing then
'do something
end if
Next iCtr
I have a list of worksheet code names in mywsnames. I'd like to set the
aws to be the name in the mywsnames list. It's not working. What do I need
to change?
Thanks
|