copy workbook

[Johan]

Hi,

I want to do the following with a macro:

Msgbox: "copy?" if Yes
Then
Active wbk – sheet1 – range("name1") and active wbk – sheet2 –
range("name2") copy to new wbk without formulas and macro.
Then
Save as: range("name").xls

Please, can anyone help me!

Thanks in advance,

Johan

 

[Nick Hodge]

Johan

One possible answer in Worksheet.Functions

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)