Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 13 type mismatch ?
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 -- Joe ----------------------------------------------------------------------- JoeH's Profile: http://www.excelforum.com/member.php...fo&userid=1413 View this thread: http://www.excelforum.com/showthread.php?threadid=26346 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 13 type mismatch ?
before you use cl use
cl = Evaluate(workbooks("TestCalcs_rev22.xls").Names("T est").Referesto) Changing the name to TestCalcs_rev22.xls to the appropriate workbook. -- Regards, Tom Ogilvy "JoeH" wrote in message ... Tom, I tested taking out the CL value and actually hard coding a row and it worked. Now in reference to my above question, i named a cell test and wrote the value of CL into it. Now how do i retrieve that value and use it in the code in the place of CL ........ rows(cl) needs to be rows( what ever is in cell test ). Thanks for putting me on the right track joe -- JoeH ------------------------------------------------------------------------ JoeH's Profile: http://www.excelforum.com/member.php...o&userid=14138 View this thread: http://www.excelforum.com/showthread...hreadid=263468 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
Runtime Error 13 - type mismatch | Excel Discussion (Misc queries) | |||
Runtime error 13 type mismatch ? | Excel Programming | |||
Runtime error 13 type mismatch ? | Excel Programming | |||
Runtime error 13 type mismatch ? | Excel Programming |