![]() |
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 |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com