Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using Excel 2003, Win XP Pro SP2
I have code that reads in an array from a worksheet Stage1(), processes the array and then writes it again back to the same worksheet. The read is happening correctly. But I get the application-defined or object-defined error when trying to write the array to the worksheet. Sub ReadStage1() With Workbooks("WIPBOM.xls").Sheets("Stage1") Stage1Count = .Range(.Range("A2"), ..Range("A2").End(xlDown)).Rows.Count - 1 Stage1Cols = .Range(.Range("A2"), ..Range("A2").End(xlToRight)).Columns.Count 'Set new array variables ReDim Stage1(0 To Stage1Count, 1 To Stage1Cols) 'Read in Styles to array variable For LoopStage1 = 0 To Stage1Count For LoopCols = 1 To Stage1Cols Stage1(LoopStage1, LoopCols) = ..Range("A2").Offset(LoopStage1, LoopCols - 1).Value Next LoopCols Next LoopStage1 End With Code here manipulates variables in the array- code is too long to post. Going into the next sub, Stage1Count=2638 and Stage1Cols=74 and array is fully populated. Sub Write_Stage_1 With Workbooks("WIPBOM.xls").Sheets("Stage1") .Range("A2:IV60000").ClearContents .Range("A2").Resize(Stage1Count, Stage1Cols).Formula = Stage1() End With End Sub I get an application-defined or object-defined error on the ..Range("A2").Resize(Stage1Count, Stage1Cols).Formula = Stage1(). It executes the previous Clear Contents line line without error. I have struggled with this type error for as long as I have been teaching myself coding. I really need to find what I am doing incorrectly. Thanks, Brent |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming |