shorter way?

M

Me !

I have a macro in excel that fills a form for a branch and then print it for
90 times.

I want to send them by email and for this i need to send a file to each
branch.

Instead of
Cells.select
Cells.copy
....
workbooks.add
.......
activeworkbook.save .... and so on

is there a shorter way for putting a sheet separated in another file?
 
Top