This should do it
myPath = Range("A1")
hth
Ajay