how to write this in vbe ???

  • Thread starter Thread starter pls123
  • Start date Start date
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??
 
Try this.....

Range("A2").Formula = "='C:\WB\[@@@@PLT@@@@INTC.O.DIS.xlsm]Sheet2'!$I$7"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can write this as workbook function ??? 3
calling sub from other workbook 1
vbe - copy a cell's value by other workbook 2
automatic replacing of vbe code for multiple workbooks 1
Lost post Re VBE 3
My Never ending ARRAY code problems 18
if then nested in a for next ?? 4
Excell to Web Form filling macro 0

Back
Top