Copy 1-4 sheets to a new workbook
Hi,
I have a problem finding out how to copy 4 sheets (mymaster.xls) to another
workbook (newWB.xls), the 4
sheets should have the rowheights and formats also copied to the new
workbook,
another problem is that the master.xls have alot of commandbuttons and other
code that i dont want in the newWB.
The area that i want copied in every worksheet is A1-S34 in that area there
is now commandbuttons.
I really hope that there is someone who can help me.
thanks,
Ole
|