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

Setting aws to name stored in an array
 

Maybe: If aWS Not Is Nothing Then
'Do something

"Barb Reinhardt" wrote:

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

Setting aws to name stored in an array
 

Had the syntax wrong: If Not aWS Is Nothing Then
'Do Something

Sorry bout that!

"Barb Reinhardt" wrote:

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