ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   assigning array back to range (https://www.excelbanter.com/excel-programming/316418-assigning-array-back-range.html)

Jane

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



Jane

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




All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com