Compile Error: Invalid ReDim

[welchs101]

Hi,

I have the following code which causes an error:

Please Login or Register  to view this content.

However, i will now SWAP the order of the if-statements and the following code passes:

Please Login or Register  to view this content.

can someone explain it to me? I have also submitte my actual file incase some one wanted to see it.

[JieJenn]

From your test array fails module, type Dim junk_array() As Variant in the beginning of the module then try again.

And, I am not sure if you can assign a value to a range. ' junk_array = ws.Range("A1:B" & last_row_1).Value

[Norie]

Try declaring junk_array, as well as all your other variables eg ws, last_row1 etc.

[Andy Pope]

It's the position of the redim statement after the first instance of the variable. the compiler makes an assumption based on first encounter and then subsequent syntax breaks that assumption.

If you declare junk_array at the top the compile problem goes away

Please Login or Register  to view this content.

[welchs101]

thanks for responding.

Andy, i tried what you suggested and it worked great! thanks.

I dont know why but i have had trouble with this kind of thing in the past and i think its because i dont know how to declare arrays properly.

for example

Dim Junk1_array as variant


is not the same as

Dim Junk1_array() as variant



do any of you know a link which explains this difference and others for declaring arrays and how to do it.

thanks!

[Andy Pope]

useful reading

http://www.cpearson.com/excel/vbaarrays.htm
http://www.tushar-mehta.com/publish_...variants.shtml

[welchs101]

thanks for the info