Type Mismatch problem

I am getting a Type Mismatch error on the line ' symbols = Array(ChrW(&H2665), ChrW(&H2666))' I can't fix it. I'd appreciate any advice, please.

Please Login or Register  to view this content.

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time to expedite the thread. --6StringJazzer

The Array function returns a Variant, even if all the elements are String. You must declare symbols as Variant. Your code should work with no other changes, however I highly recommend that you declare Symbol. The way you are using it, it must be declared as Variant. It defaults to Variant if you don't declare it, but I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.