Expected Array Error

[Najwa_X]

Hello All,

I am having an error with " Expect array " Point at the red Row.

This function is called in my Main SuB I don't think the error is related. What would be the cause as I can not see the error.

Your help is much appreciated.

Thank you.

Najwa.

Please Login or Register  to view this content.

[Marc L]

Salut !

What is the value of the variable i ? …

[torachan]

you have declared 'a' as an integer, try 'Variant'

[Andy Pope]

You are declaring a as a integer in the list of arguments, there for you can not redim.
Looking at the code you are using a to hold temporary information so rename the variable.

To clarify, rename the a variable you redim

Please Login or Register  to view this content.

[Fluff13]

You are currently passing a value to the function, only to destroy it.
Change the name of your array

[Najwa_X]

Salut Marc,

The value of the variable i is integer . It is counting the number of rows of Range X. You think it is related ?

Merci.

[Najwa_X]

Ho Torachan,

I tried Variant . Same error .

Thank you !

[Najwa_X]

Ok will Correct it

[Najwa_X]

Indeed ! Got mixed with variables !

Thx a lot for your help !

Najwa.

[Fluff13]

You're welcome & thanks for the feedback