Frank,

Thans very much for replying.

Most of the details are in the previous posts but, here is the crux o
the matter:

I have declared and set the following:

Dim OCB As Workbook
Dim OCS As Worksheet
Set OCB = ActiveWorkbook - (activeworkbook is called 1709cds.xls)
Set OCS = OCB.ActiveSheet - (activesheet is called 1709cds)

Further on in the code I am trying to use the following function:

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

In this format it works just as I'd like but I want to change th
hardcoded workbook reference to a variable (hopefully either OCB o
OCS). However this is where it falls over and I just can't get it t
work!

I was kindly offered the following by others on this site but thes
don't work either:

CRMatchRange.FormulaR1C1 = "=IF(ISNA(MATCH(RC[6],'" & OCB
"'!R2C1:R1421C1,0)), today()," & Chr(34) & "Current Item" & Chr(34)
")"

I'm pulling my hair out for what, I thought, would be an easy fix an
dumb oversight on my behalf?

Any help would really be appreciated.

Thanks,

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=27626