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