View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default set variable to activeworkbook

A question occurred to me about setting a variable to the active
workbook. If I set the variable equal to "Activeworkbook", then later
activate another workbook, does the variable now refer to the current
active workbook, or to the same workbook as when it was assigned?