how to write this in vbe ???

P

pls123

hi all
i have this :
='C:\WB\[@@@@PLT@@@@INTC.O.DIS.xlsm]Sheet2'!$I$7

for some reason..
i must have it in vbe !!
something like this...
Range("A2") = Range("'C:\WB\[@@@@PLT@@@@INTC.O.DIS.xlsm]Sheet2'!$I$7")
without using the '
can anybody help??
 
N

Nigel

Try this.....

Range("A2").Formula = "='C:\WB\[@@@@PLT@@@@INTC.O.DIS.xlsm]Sheet2'!$I$7"
 
Top