assigning array back to range
 

I am verifying/updating multiple rows (equal to a "product") at a time
through a Form. I assign a range of rows (= a product) to an array and
update the form controls from that and write back to the array.

I then try to assign the array back to the range to write to the worksheet
(after I delete the original product rows). In a simple version of this it
worked fine. But now with additional processing of the array I get a 424
run-time error on

rgHeader.Value = vaHeader

Any ideas of what to check?

Thanks

vaHeader consists

assigning array back to range
 

424 is "Object required"

"Jane" wrote:

I am verifying/updating multiple rows (equal to a "product") at a time
through a Form. I assign a range of rows (= a product) to an array and
update the form controls from that and write back to the array.

I then try to assign the array back to the range to write to the worksheet
(after I delete the original product rows). In a simple version of this it
worked fine. But now with additional processing of the array I get a 424
run-time error on

rgHeader.Value = vaHeader

Any ideas of what to check?

Thanks

vaHeader consists