Will this copy all th epages to one page ina new work book?

Yes it copy a range from each sheet to one sheet in the new workbook


What I am trying to do is past 30 sheets with formulas to a new
workbook and end up with 30 sheets with just value and format from
themaster workbook.

That is not what you ask ?

See the examples on this page
http://www.rondebruin.nl/tips.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"dreamkeeper" wrote in message oups.com...
Thanks Ron.
Will this copy all th epages to one page ina new work book?

What I am trying to do is past 30 sheets with formulas to a new
workbook and end up with 30 sheets with just value and format from
themaster workbook.
I thought i hsould explain that before I tried this!
any insight?
Thanks,
Tina