View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ralph L Ralph L is offline
external usenet poster
 
Posts: 1
Default 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