With code you can do this
http://www.rondebruin.nl/copy7.htm

Or
http://www.rondebruin.nl/ado.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Graham F" wrote in message ...
Hi Group, I need to be able to read a block of cells, say a1:d10 on sheet 1
from a workbook without opening it, and then show the value of those cells in
my currently open workbook. I know you can use links, but is there another
way? Any help would be appreciated. Many thanks Graham.