Thread: ThisWorkbook/ActiveWorkbook
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
chubster264[_6_] chubster264[_6_] is offline
external usenet poster
  
Posts: 1
Default ThisWorkbook/ActiveWorkbook

Thisworkbook is always the workbook within which the macro is stored.
Activeworkbook is any member of the Workbooks collection - activated by
Workbooks(xx).activate

:)


--
chubster264
------------------------------------------------------------------------
chubster264's Profile: http://www.excelforum.com/member.php...o&userid=30164
View this thread: http://www.excelforum.com/showthread...hreadid=510304

Reply With QuoteReply With Quote