LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Application-defined or object -defined error continually haunting me

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run-time error '50290': Application-defined or object-defined erro Macro button Excel Discussion (Misc queries) 1 March 12th 09 10:59 AM
Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined Matt[_39_] Excel Programming 3 July 25th 06 01:13 AM
Runtime error 1004- application defined or object defined erro Novice Excel Programming 0 February 6th 06 09:34 PM
Runtime error 1004- application defined or object defined erro Novice Excel Programming 1 February 6th 06 09:33 PM
Runtime error 1004- application defined or object defined erro Jim Thomlinson[_5_] Excel Programming 0 February 6th 06 09:29 PM


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"