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

It should be:

Range("MyLocalRange").Value =
Workbooks("MyRemoteWorkbookName").Range("RemoteRan ge").Value