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??