Dear Jacob,

Thank you for your help.
I will post the vba code between tags it looks much better, and easy to understand.

For the code adjustment , I am afraid I couldnt get it work.

I have just replace the last line of the code with the one you provide.
I have changed the "MyWorkbookName" to source book name and the "MyWorksheetName" to source book sheet name.

I have past this code to destination workbook module.

When I run the code , inputbox comes up for marking where the paste should start.
But nothing happens.

I cannot switch the other workbook..

What I realy want do is :

Load the specific workbook, select multiple areas , copy them to
destination workbook .
(source workbooks will be be more then one , I will load them accordingly
select some multi-cells to copy and paste to destination workbook)
Is it possible?

Regards
Ertan