View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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