3-D reference for a range? (not just a cell)

[lindasf]

MS-EXCEL 2000 HELP implies that I can create a 3-D reference for a range
(not just a cell).

Is this possible? I’ve tried everything, but keep getting #VALUE!

I need to link about 200 contiguous cells from one workbook to another,
so obviously don’t want to link them one by one.

Thx.

 

[Biff]

Hi!

It depends on which functions you are using the range
reference in. Post more details.

Biff

 

[Tushar Mehta]

Option 1: Select the 200 cells. Copy. Switch to the 2nd workbook and
select the first destination cell. Select Edit | Paste Special... |
'Paste link' button

Option 2: This is how I would do it. Select the 200 *destination*
cells. Press the = key. Use the mouse and select the 200 source cells
(the source and destination ranges should be the same shape and size).
Complete data entry with CTRL+SHIFT+ENTER rather than just ENTER. By
entering it as an array formula, it is self-evident that you mean to
treat the range of 200 cells as one 'entity.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions