Excel 2000 -> Excel 2003 now throws 'runtime error'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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>
 
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
 
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!
 
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?
 
Back
Top