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