View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Candyman Candyman is offline
external usenet poster
 
Posts: 66
Default retrieving cell value from a query linked workbook

Have not thought of that.
Thanks!

"Greg Glynn" wrote:

Correction:


Range("MyLocalRange").Value =
Workbooks("MyRemoteWorkbookName").Sheets("RemoteSh eetName").Range("RemoteRange").Value