First, thanks Dave for your tips.

Now, I try to run the code to copy the same range (say A1:L10)from 2
workbooks. The code suppose to copy the range values from first sheet
in each workbook. It does copy the range I needed into the first sheet
but only values from workbook 1 and no values from workbook2. Seems
that somthing to do with the looping. I am now seeking for help to do
something with the code so that once the macro is run, the same ranges
for all the workbook can be copied into the sheets accordingly.

Is this possible to do? Thankyou very much in advance.

Regards,
amy


--
jonesaa05
------------------------------------------------------------------------
jonesaa05's Profile: http://www.excelforum.com/member.php...o&userid=28021
View this thread: http://www.excelforum.com/showthread...hreadid=475287