View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Pathname reference

you can use INDIRECT if both are open

--
Don Guillett
SalesAid Software

"SB1979" wrote in message
...
I am trying to use a reference cell in another workbook as part of my
pathname. Is there a way to do this?

Thanks for your help