first workbook for 6 sheets and I would like to copy each sheet data (selected range) from this 6 sheets and paste on another workbook … Try to use excel application scope by it not allow to open 2 workbook together … Please help!
A lot of usefull stuff you may find here:
Additonally there are tons of topics related to excel. Just try use search function. Here you have example: