| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 - Excel 2003 now throws 'runtime error'
Hello - thanks for reading.
When I try to use a spreadsheet button someone design in Excel 2000, it now throws an "Run-time error '1004': Application-defined or object-defined error". I am copying the snipit of code that the debugger highlights as the culprit... I have NO idea how to fix this, so some assistance would be graciously appreciated! <code ActiveSheet.Range("C" & CStr(DestRow)) = "=UpdateScore(""" & ThisSheetName & """,""" & _ Sheets(ThisSheetName).Range(ACell) & """,'" & ThisSheetName & "'!C" & CStr(TotalRow) & ":IX" & _ CStr(TotalRow) & ")" </code |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 - Excel 2003 now throws 'runtime error'
ThisSheetName = "thisSheetName"
Acell = "A1" TotalRow = 20 ? "=UpdateScore(""" & ThisSheetName & """,""" & _ Sheets(ThisSheetName).Range(ACell) & """,'" & ThisSheetName & "'!C" & CStr(TotalRow) & ":IX" & _ CStr(TotalRow) & ")" =UpdateScore("thisSheetName","AABB",'thisSheetName '!C20:IX20) The statement appears to be syntactically correct. So problems could result from the definition of any of the variable values ThisSheetName Acell What is contained in Sheets("ThisSheetName").Range(ACell) TotalRow DestRow The definition and existence of the function UpdateScore You are the only one who can check those -- Regards, Tom Ogilvy "Ralph L" <Ralph wrote in message ... Hello - thanks for reading. When I try to use a spreadsheet button someone design in Excel 2000, it now throws an "Run-time error '1004': Application-defined or object-defined error". I am copying the snipit of code that the debugger highlights as the culprit... I have NO idea how to fix this, so some assistance would be graciously appreciated! <code ActiveSheet.Range("C" & CStr(DestRow)) = "=UpdateScore(""" & ThisSheetName & """,""" & _ Sheets(ThisSheetName).Range(ACell) & """,'" & ThisSheetName & "'!C" & CStr(TotalRow) & ":IX" & _ CStr(TotalRow) & ")" </code |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 - Excel 2003 now throws 'runtime error'
Tom/All,
This works flawlessly in Excel 2000 - and only breaks on my Excel 2003 installation. So my guess that the rest is correct... this is the reason I've come to the community - I'm lost as to what's going on... Thanks! "Tom Ogilvy" wrote: ThisSheetName = "thisSheetName" Acell = "A1" TotalRow = 20 ? "=UpdateScore(""" & ThisSheetName & """,""" & _ Sheets(ThisSheetName).Range(ACell) & """,'" & ThisSheetName & "'!C" & CStr(TotalRow) & ":IX" & _ CStr(TotalRow) & ")" =UpdateScore("thisSheetName","AABB",'thisSheetName '!C20:IX20) The statement appears to be syntactically correct. So problems could result from the definition of any of the variable values ThisSheetName Acell What is contained in Sheets("ThisSheetName").Range(ACell) TotalRow DestRow The definition and existence of the function UpdateScore You are the only one who can check those -- Regards, Tom Ogilvy "Ralph L" <Ralph wrote in message ... Hello - thanks for reading. When I try to use a spreadsheet button someone design in Excel 2000, it now throws an "Run-time error '1004': Application-defined or object-defined error". I am copying the snipit of code that the debugger highlights as the culprit... I have NO idea how to fix this, so some assistance would be graciously appreciated! <code ActiveSheet.Range("C" & CStr(DestRow)) = "=UpdateScore(""" & ThisSheetName & """,""" & _ Sheets(ThisSheetName).Range(ACell) & """,'" & ThisSheetName & "'!C" & CStr(TotalRow) & ":IX" & _ CStr(TotalRow) & ")" </code |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 - Excel 2003 now throws 'runtime error'
what is "UpdateScore"? Is it maybe another macro stored in some other Excel
file that was not copied over to your new Excel 2003 file? "Ralph L" wrote: Tom/All, This works flawlessly in Excel 2000 - and only breaks on my Excel 2003 installation. So my guess that the rest is correct... this is the reason I've come to the community - I'm lost as to what's going on... Thanks! "Tom Ogilvy" wrote: ThisSheetName = "thisSheetName" Acell = "A1" TotalRow = 20 ? "=UpdateScore(""" & ThisSheetName & """,""" & _ Sheets(ThisSheetName).Range(ACell) & """,'" & ThisSheetName & "'!C" & CStr(TotalRow) & ":IX" & _ CStr(TotalRow) & ")" =UpdateScore("thisSheetName","AABB",'thisSheetName '!C20:IX20) The statement appears to be syntactically correct. So problems could result from the definition of any of the variable values ThisSheetName Acell What is contained in Sheets("ThisSheetName").Range(ACell) TotalRow DestRow The definition and existence of the function UpdateScore You are the only one who can check those -- Regards, Tom Ogilvy "Ralph L" <Ralph wrote in message ... Hello - thanks for reading. When I try to use a spreadsheet button someone design in Excel 2000, it now throws an "Run-time error '1004': Application-defined or object-defined error". I am copying the snipit of code that the debugger highlights as the culprit... I have NO idea how to fix this, so some assistance would be graciously appreciated! <code ActiveSheet.Range("C" & CStr(DestRow)) = "=UpdateScore(""" & ThisSheetName & """,""" & _ Sheets(ThisSheetName).Range(ACell) & """,'" & ThisSheetName & "'!C" & CStr(TotalRow) & ":IX" & _ CStr(TotalRow) & ")" </code |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Runtime Error | Setting up and Configuration of Excel | |||
| Runtime error prevents Excel 2000 to save file | Excel Worksheet Functions | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
| Excel 2003 Help Runtime Error | Excel Discussion (Misc queries) | |||
| Calling from C#.Net App Office._CommandBarButton.Execute() method in Excel 2003 throws a COMException | Excel Programming | |||
Hybrid Mode
