Getting a mismatch on operator when testing for variant and string

**BeefNoodleSoup** · 04-09-2012, 08:01 PM

Pretty simple function and I apologize in advance for posting but I've been stuck for a while on something fairly simple.

I'm getting type mismatch on the If statement below

I'm calling a function here:

Please Login or Register  to view this content.

Here is the actual function I'm calling:

Please Login or Register  to view this content.

Range("sheetBehavior") is a one-dimensional range of sheet names

I'm missing something simple here

**rylo** · 04-09-2012, 08:19 PM

Hi

1) you are missing the index on the 4th test.
2) there seems to be a dim missing on the arrlistsheets
3) you don't initialize the array arrlistsheets
4) you don't index the array when bringing back the result of the function

HTH

rylo