View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave K Dave K is offline
external usenet poster
 
Posts: 16
Default Select Previously Selected worksheet (and/or select previouslyselected workbook)

Is anyone aware of VBA code that would allow me to auto-select the
previously active worksheet (within a particular workbook....or within
another open workbook)?

In essence, I am trying to build a routine that will allow me to
automatically do a vlookup between two data lists in two sheets with a
single step, rather than go through the process of specifying the
particular columns

Thanks for any suggestions.

FYI, i am using Excel 2003.