I am trying to have a cell refer to a work book which can be filled and
cleared with a macro. What i am trying to do is have the path to the
other workbook in a cell.

This is what i have now:

Range("D3").FormulaR1C1 = _
"=IF(RC[-2]='C:\GLEXCEL\" & [H4] &
"LEDGER'!RC[-2],'C:\GLEXCEL\" & [H4] & "LEDGER'!RC[2],0)"
Range("D3").AutoFill Destination:=Range("D3:D123"),
Type:=xlFillDefault
Calculate

Now i want to change that so i have to put the full path in H4 and have
the code just look there but when ever i try that it does not work.

Any ideas anyone?

Thanks,
Arthur