I need to loop through my code using a counter index which i
non-systematic. For example, j = 1,3, 11,12,30,40,99 .... I intuitivel
attempted the following (based on j in this example) but which failed.

For i = 1 To 7
For j = Array( 1,3, 11,12,30,40,99)
Cells(j, "a") = "testing"
Next
Next

The idea is to get the loop working the first time and then apply a
outer loop to run through several sheets with identical spreadshee
format.

Thanks for any help.

Davi

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=37891

also:

dim vRow as variant
for each vRow in Array(1,3,11)
activesheet.Cells(vRow,1) = "test"
next




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


davidm wrote :


I need to loop through my code using a counter index which is
non-systematic. For example, j = 1,3, 11,12,30,40,99 .... I
intuitively attempted the following (based on j in this example) but
which failed.

For i = 1 To 7
For j = Array( 1,3, 11,12,30,40,99)
Cells(j, "a") = "testing"
Next
Next

The idea is to get the loop working the first time and then apply an
outer loop to run through several sheets with identical spreadsheet
format.

Thanks for any help.

David