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
|