in file x i have address in cell A1 : +'[y.xls]sheet1'$A$5
which refers to file y
by dubll click i can jamp to this file

i want to build a macro that will do this operation
assume that file y is allways open
can you help me in a.s.a.p

thank you
rozent

*** Sent via Developersdex http://www.developersdex.com ***