Type mismatch error

[Christian411]

Hi,

I have the following code which is giving me a type mismatch error:

Please Login or Register  to view this content.

The error occurs in the following part of the code. The values that I'm copying into the Code(i) array are items of text which is why I declared them as the 'variant' type of data. VBA is still not happy though.

Please Login or Register  to view this content.

Does anyone have any ideas where this is going wrong?

Thanks,

Chris

[DonkeyOte]

If you want to use Column 54 use

Please Login or Register  to view this content.

Note also that Option Base is by default 0 so

Code(11) is a 12 value array (0 to 11) ... it would appear you want an 11 value array, so either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

(or set Option Base to 1 at top of Module)

The alternative approach would be to use the below to populate the Array thereby avoiding need to Loop:

Please Login or Register  to view this content.

[Christian411]

Thanks for that, but still no joy unfortunately.

I have set the option base as 1 at the very start of editor (I have several other macros). I think therefore that Code(11) is right. I did try your other suggestion about using the alternative instead of looping to fill the array. This worked but my code fell over later on at the line:

Please Login or Register  to view this content.

Where it told me 'subscript out of range'?

Do you possibly have any other suggestions?

Thanks very much again!

Chris

[DonkeyOte]

I will take a look in a while - up to my eyes in my own code presently ... if in the meantime anyone else can spare the time to check this out in more depth I'd be grateful.

[Andy Pope]

You need to tell us what the values in the variables are
So immediately before that line add

Please Login or Register  to view this content.