Thread: absolute reference to sheet in other workbook
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Brassman[_8_] Brassman[_8_] is offline
external usenet poster
  
Posts: 1
Default absolute reference to sheet in other workbook

Although the sheet reference needs to be absolute, the workbook
reference is only loosly absolute. The source and destination
workbooks change each year, and the macro looks at the workbooks that
are currently open in order to determine which ones to use. Thanks
though.


--
Brassman
------------------------------------------------------------------------
Brassman's Profile: http://www.excelforum.com/member.php...o&userid=13290
View this thread: http://www.excelforum.com/showthread...hreadid=495535

Reply With QuoteReply With Quote