why doesn't this conditional wok?
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
Next
If flg = True Then
DirectCopyInfo = True
'do nothing
Else
Sheets.Add.Name = MyArray(2)
DirectCopyInfo = False
End If
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
Next
If flg = True Then
DirectCopyInfo = True
'do nothing
Else
Sheets.Add.Name = MyArray(2)
DirectCopyInfo = False
End If
Last Comment
what do you meant by:
MyArray(2) is Dog
how does it translate in VBA ??? all the rest is fine. The only hick-up is
MyArray(2) is Dog
This is un heared of for me so far !!!
gowflow
MyArray(2) is Dog
how does it translate in VBA ??? all the rest is fine. The only hick-up is
MyArray(2) is Dog
This is un heared of for me so far !!!
gowflow
What the Author means is that somewhere in the code he has something like
MyArray(2) = "Dog"
MyArray(2) = "Dog"
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
you write "fig" but in the code you write "flg"
please make sure it's not a plain "typo" ...
please make sure it's not a plain "typo" ...
I don't see hjow your Flg goes to True
check out this file make sure macroes are set to enabled
noted also as angelIII pointed out the fig and flg maybe a typo in your code setting already fig to True whyle ur looking for flg ??
gowflow
test.xls
check out this file make sure macroes are set to enabled
noted also as angelIII pointed out the fig and flg maybe a typo in your code setting already fig to True whyle ur looking for flg ??
gowflow
test.xls
ASKER
copy don't type is the rule
l and i are not interchangeable except to us blind guys
gary
l and i are not interchangeable except to us blind guys
gary
Thanks, Gary.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
This article of mine may help you. It's aimed at VB6 but most of it allies to VBA.