Hi Ken

Select the range
Ctrl-C to copy
Right click on the destination cell
Paste Special
Click on Paste Link

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



"ken's dilemma" <ken's wrote in message
...
how do i link a range of cells in one worksheet to a range of cells in
another worksheet? i want the cells to update as i change the originals. i
can link one cell..but when i try to link a range it gives me the #VALUE.
thanx