Hi

See this mail macro for the code
Delete the mail stuff
http://www.rondebruin.nl/mail/folder1/mail4.htm

If you need more help post back



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
Hello,
I have this problem, i want create a macro that create a new file with
a Range (Ex A1:B56)

Ex.
In the file X i have 4 sheets i want a macro that take all the data
From The sheet1 in the range A1:B56 and save this range as file Y.

I hope you understand what i need to do :) thanks in advance to every
one.