ExcelBanter - how to write this in vbe ???

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how to write this in vbe ??? (https://www.excelbanter.com/excel-programming/420068-how-write-vbe.html)

pls123

how to write this in vbe ???

hi all
i have this :
]Sheet2'!$I$7

for some reason..
i must have it in vbe !!
something like this...
Range("A2") = ]Sheet2'!$I$7")
without using the '
can anybody help??

Nigel[_2_]

how to write this in vbe ???

Try this.....

Range("A2").Formula = ]Sheet2'!$I$7"

--

Regards,
Nigel

"pls123" wrote in message
...
hi all
i have this :
]Sheet2'!$I$7

for some reason..
i must have it in vbe !!
something like this...
Range("A2") = ]Sheet2'!$I$7")
without using the '
can anybody help??

All times are GMT +1. The time now is 11:13 PM.