I'm loop through my data and need to set up an array based on some
conditions. Basically I'd like to do something like this:

for j=1 to 18
for rowcount=1 to 1000
if cells(rowcount,2) like "I" then
if cells(rowcount,3) like "A" or "B" or "C" then
myarray(j) = myarray(j) + cells(rowcount,4)
end if
end if
next rowcount
next j

What's the code for that? Thanks!


---
Message posted from http://www.ExcelForum.com/