lijon
01-22-2010, 12:54 PM
Hi folks,
I inherited a macro at work. It usually runs fine, but now breaks down.
The error # and error msg box comes back as
"1004 - Application-defined or object-defined error"
I've only included the part where it breaks down since its so huge ...and I suspect its in the syntax or somethihng here.
-------------------------------------------------------------------
If CurrFile = "US" Then (it does = US)
ActiveCell.Offset(0, 8).Formula = "=RtGet(""IDN"",A" & ActiveCell.Row & ",""OFFCL_CODE"")"
ActiveCell.Offset(0, 7).Formula = "=VLOOKUP("" "" & RIGHT(I" & ActiveCell.Row & ",LEN(I" & ActiveCell.Row & ")-3),'c:\[Available.xls]Inventory'!$A:$T,4,FALSE)"
this is where it breaksdown
Else
ActiveCell.Offset(0, 8).Value = 0
-----------------------------------------------------------------
Would love some help interpreting the "1004" error msg this generates.
The size of the file this macro in and the file referenced (available.xls) have recently grown, they're both 10mb files now so I wonder if its a memory related issue as well.
thanks much!!
I inherited a macro at work. It usually runs fine, but now breaks down.
The error # and error msg box comes back as
"1004 - Application-defined or object-defined error"
I've only included the part where it breaks down since its so huge ...and I suspect its in the syntax or somethihng here.
-------------------------------------------------------------------
If CurrFile = "US" Then (it does = US)
ActiveCell.Offset(0, 8).Formula = "=RtGet(""IDN"",A" & ActiveCell.Row & ",""OFFCL_CODE"")"
ActiveCell.Offset(0, 7).Formula = "=VLOOKUP("" "" & RIGHT(I" & ActiveCell.Row & ",LEN(I" & ActiveCell.Row & ")-3),'c:\[Available.xls]Inventory'!$A:$T,4,FALSE)"
this is where it breaksdown
Else
ActiveCell.Offset(0, 8).Value = 0
-----------------------------------------------------------------
Would love some help interpreting the "1004" error msg this generates.
The size of the file this macro in and the file referenced (available.xls) have recently grown, they're both 10mb files now so I wonder if its a memory related issue as well.
thanks much!!