Problems usinga a variable in a worksheet function?
 

[1709cds.xls]Sheet1!R1C1

would be a reference containing a workbook name (you must specify a
worksheet as well). Could this be you error?

(if you have spaces in the names, you might need single quotes as well. )

--
Regards,
Tom Ogilvy

"Kobayashi" wrote in message
...

In the below snippet of code I am trying to replace the hardcoded
'1709cds.xls' workbook reference with the name of a variable that I
have already declared for the workbook - OCB. However, try as I may
(and I certainly have!) I cannot get it to work.

Any help would be very much appreciated!


CRMatchRange.FormulaR1C1 =
"=IF(ISNA(MATCH(RC[6],'1709cds.xls'!R2C1:R1421C1,0)), today(),""Current
Item"")"


Thanks,

Adrian


--
Kobayashi
------------------------------------------------------------------------
Kobayashi's Profile:
http://www.excelforum.com/member.php...nfo&userid=871
View this thread: http://www.excelforum.com/showthread...hreadid=276260