Excel 2003 - 2010 upgrade; help with Macro Error

Ben.Hutt · #1 (**permalink**) 05-20-11, 10:41

I just updated Microsoft Office from 97-2003 to Office 2010, and one of my main control macro's stopped working.

I've isolated the problem to where I'm trying to name a specific cell range, where I get a "Runtime Error '13': Type Mismatch" error.

Any help would be much appreciated, as I'm still learning the basics of VB, and actually inherited this spreadsheet from a previous employee (so I don't completely understand what all of the lines actually do).

Erroring Code:

ActiveWorkbook.Names.Add Name:="ISOdata", RefersToR1C1:= _
"=IsoTrain!R3C1:R" & Cells(1, 1).Value + 3 & "C23"

Colin Legg · #2 (**permalink**) 05-20-11, 17:19

Hi Ben and welcome...

If you break that code out as follows, what do you see in the immediate window when you run the code?

Code:

Dim strRefersTo as String
 
Debug.Print Cells(1,1).Value
 
strRefersTo = "=IsoTrain!R3C1:R" & Cells(1, 1).Value + 3 & "C23"
 
Debug.Print strRefersTo
 
ActiveWorkbook.Names.Add Name:="ISOdata", RefersToR1C1:= strRefersTo

Internet Services

Web Development

Digital Marketing

Consumer Tech