Copy sheets and remove named range

[digdug]

Andy,

Sorry to jump in the middle of your post, but I am working an a project that requires a similar code.

I used the code from Rylos file in the earlier post to get started, but would like to expand the code to copy only two specific sheets "Summary" and "Equipment" to a new workbook (without selecting them each time) and then deleting a specified named range "Costs" from the "Equipment" sheet after pasting as values only in the new workbook.

I am pretty new to Visual Basic, and appreciate all the help I can get.

Thanks

[rylo]

digdug

Please read the forum rules. Do not hijack an existing thread for you own but start a new thread. Place a reference to the other post where applicable.

refer to this thread

rylo