Need help in using 'For' function with arrays

[2011]

Hi,

General For Loop function in VBA excel macro starts with:

Dim i

For i = 1 To 5
..
.......

Is it possible to assign an array to FOR func.?

example:

For i = {10; 28; 35; 40; 56}

so i can assign differnet values to 'i'.

If yes, then what shall be correct code to define it?

Thank you in advance.

[jason.b75]

Try something like

Please Login or Register  to view this content.

where v(i) will return the value from the array.