View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default How to copy to a specific worksheet?

BTW, it was on page 17 of Walkenbach's excellent 'Excel 2000
Programming
for Dummies' (my most recent book!) that I read "If you omit specific
references, Excel uses the *active* objects."


...and so is why 'Best Practice' recommends using *fully qualified refs!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion