Export Sheet Values to new workbook

M

mp

GS said:
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
Click to expand...

thanks again, Garry
Will try those out
mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save workbook without shapes 0
Dumb question alert! What program to use? 0
Shift Collate sheet 1-20 when printing entire workbook? 0
selecting workbook/sheet 3
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Unprotect sheet when Saving As 2
Emailing a sheet from a workbook with VBA 0
Export tracked changes to a new document 0

Top