Runtime error 13 type mismatch ?

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

JoeH

Tom,

I tested taking out the CL value and actually hard coding a row an
it worked. Now in reference to my above question, i named a cell tes
and wrote the value of CL into it. Now how do i retrieve that value an
use it in the code in the place of CL ........ rows(cl) needs to b
rows( what ever is in cell test ).

Thanks for putting me on the right track
jo
 
before you use cl use

cl = Evaluate(workbooks("TestCalcs_rev22.xls").Names("Test").Referesto)

Changing the name to TestCalcs_rev22.xls to the appropriate workbook.
 

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

Runtime error 13 type mismatch ? 1
Sumif within loop 1
Runtime error 13 type mismatch ? 1
Output from a userform finding the right column. column 1
Cycling through one column in a range 1
Copy Data From Above 4
Excel VBA Loop & Variable Reference 2
conditional formatting vba code and calculation 1

Back
Top