Runtime error 13 type mismatch ?

  • Thread starter Thread starter JoeH
  • Start date Start date
J

JoeH

Tom,

Great work as always. I had to use ReferstoRange.Value to actuall
get to work (xp03 if it makes a difference). But again all credit goe
to you !!!!!

Thank you very much
Jo
 
Misunderstood that Test referred to a cell. Thought the name test contained
the value of for CL

Name: Test
RefersTo =25

So you did the right thing with ReferstoRange, but you don't need the
evaluate (if you still used that)

cl = workbooks("TestCalcs_rev22.xls").Names("Test").ReferestoRange.Value
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB error, runtime error 13 (type mismatch) 2
Error Message "Runtime error '13' Type mismatch" 4
Runtime Error Type 13 Mismatch 5
Runtime Error 13 - type mismatch 1
Type Mismatch (13) 2
MSGBOX Run-time Error '13': Type mismatch 6
Run time error 13 - type mismatch 6
GetOpenFileName + Type Mismatch error 2

Back
Top