Hi Excel Gurus.

I have bought so many VBA books but can't find the solution.

What I need to do is export or import (whatever is best.)
a range from an open work book to a closed workbook.

Range a1 to I55

how can I do this?

Please give us some ideas and I will see if I can get my money out of
these books.

thx


--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile: http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=387059