why doesn't this conditional wok?
Posted on 2013-01-07
sheet names are sheettest,save,sheettest2.
MyArray(2) is Dog
set two watches to make sure that is what is being seen.
fig is set to false
fig becomes true even though it never finds a sheet called Dog.
can someone see why????????
For Each WS In Worksheets
If WS.Name Like MyArray(2) Then flg = True: Exit For
If flg = True Then
DirectCopyInfo = True
Sheets.Add.Name = MyArray(2)
DirectCopyInfo = False