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.....)

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)

<gjfeng@yahoo.com> wrote in message
news:e3ef881b-f3b4-4c21-8947-fd4e404fa853@z24g2000prf.googlegroups.com...
> 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.....)