I am wondering how I would copy a specified range to a new workbook
using VBA.

1. Make the selection in the in and place the contents in the
first workbook -- WB1 -- onto the clipboard.

2. Create / add a new workbook -- call this WB2.

3. Past the contents of the clipboard to WB2

If anyone has some code that I can look at it would be greatly
appreciated as I can make this work with a new worksheet but and
messing it up with the new workbook.

Thanks for the help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/