i am doign a sum via vba...
Cells(rngAssyTCR.Row, rngGFTCR.Column).Value = "='[" &
AssyWkBkName & "]" & AssyWkSht1 & "'!R" & rngSumOf.Row
& "C" & incrColby1 & "/" & 1000 & "+" & Cells
(rngTCRTurnKey.Row, rngGFTCR.Column).Address(0, 0)

whihc is getting replaced as below finally in the cells as:
=[Assembly_RFC0405.xls]GF!$C$6/1000+'D116'

I am unable to understand why this apostrophe is come
before D116..
any suggestions?

thanks
monika