Referencing a string in a loop

[sintek]

Hi All

I have the following lines of code

Please Login or Register  to view this content.

How can I reference the above in a loop such as

Please Login or Register  to view this content.

[cytop]

You can't ... at least not in VBA as it doesn't support runtime evaluation of variables by name.

[sintek]

Hi cytop
Darn so how can I reference in a loop or must it be done individually.
Am trying to assist in this link:
https://www.excelforum.com/excel-pro...rate-cell.html

[Norie]

Use an array.

Please Login or Register  to view this content.

[sintek]

Thanks Norie....that will come in handy

[sintek]

Norie, How do i reference arrNum(c + 1) ' or next array meaning
i mean if there are 3 arrays

[sintek]

What I mean is if in the array loop I want to Do something until the value in A and next row = next array

[sintek]

Not to worry, got it thanks arrNum(c + 1)

[karedog]

If you put the code in "object based" module (sheet module, workbook module, class module, userform module) (not in "object-less" module a.k.a. standard module), you can define the variables as public at module declaration, then you can call these variables using callbyname() method :

Please Login or Register  to view this content.

[sintek]

Great, thanks karedog, that's gonna come in handy.

[karedog]

You are welcome, glad I can help.

Regards