View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
mp mp is offline
external usenet poster
 
Posts: 70
Default Export Sheet Values to new workbook


"GS" wrote in message
...
Actually, I never tried that this Copy method would return a wkb object.
Apparently it doesn't, which means I once again fell victim to ass-u-me!
Sorry, -my bad!

Here's a revision for both approaches, which have been tested:

[...]
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


thanks again, Garry
Will try those out
mark