David McRitchie Wrote:
Sorry I missed the part about multiple sheets being involved
with the selection. How do you intend to identify these sheets.


Hello David,

My sheets have names example data1, data2,data3.....dataX
there are about 35 cells in about 15 sheets wich are important t
transfer to a another new workbook.
most of them are cells with a formula. like: =SOM(N29:N33) but i jus
need de value from this formula.

is there away you can select al these data and copy it to a ne
workbook.
Many thnx for your time

--
captkiw
-----------------------------------------------------------------------
captkiwi's Profile: http://www.excelforum.com/member.php...fo&userid=1666
View this thread: http://www.excelforum.com/showthread.php?threadid=31873