| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning Range to Array | Excel Programming | |||
| Assigning range to array not working | Excel Programming | |||
| Assigning 10x1 array to 2nd collumn of 10x3 array | Excel Programming | |||
| Assigning array to range inside Excel Object | Excel Programming | |||
| movign data from an excel range to an array and back | Excel Programming | |||
Hybrid Mode
