Conditional Array?

[gjfeng]

cusID = Worksheets("db").Cells(intRow, 5).Value
cus = Worksheets("db").Cells(intRow, 4).Value
qty = Worksheets("db").Cells(intRow, 8).Value
Worksheets("nvT").Range("a" & Columns.Count).End(xlUp)
(2).Resize(, 3).Value = _
Array(cusID, cus, qty)


is it possible to use the value of qty. It'll only put in the value of
qty every even columns? (4,6,8,10,12.....)

 

[Bob Phillips]

I think I get what you are trying to do, but not totally sure.

Is cusID supposed to be a variable array name, or the array values?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)