Interpretting a VBA code

Deleted
Not applicable

Hi guys,

 

Just need a bit help with the very first statement of a code.

We're trying to re-code a macro which we've been using for a while. It is written in 07 I guess, and we have no way to get in touch with that person who wrote it. So I just have to read the code line by line & then try to re-write it in 2013.

 

The first line is as follow,

Dim a, address1, z1, z2, h1, h2, splitaddress, topaddress, bottomaddress As Long, c, c1, pan1, hh, zz, names, yuer, jia, strss.

 

According to my research it is said that if you wish to dim more than one variables in one line, you do like this - Dim a as Long, address a Long, z1 as long.

But the code above is like, a is "dimed" as long, then address "dimed" as c, and so on.

 

To be honest, I don't really know what does this line do, since it doesn't follow the rule.

So my question is - is the code above legit, I mean valid? If yes, then what does it do? A data type named "c",  well is "c" a same kind of thing as "Long", I wonder.

If it is not valid, then I assume Excel will skip it because it is not readable, am I right?

 

Thanks for taking time on this,

Dummy810

2 Replies

@Riny_van_Eekelen 

 

Thanks for the information.

So far I might conclude that the first line is not written properly, yet it doesn't produce a crash in the program. I'll see how it goes.