Copy and display a range

K

Ken G.

Is it possible to have the contents of a named range copied and pasted into a
new location. Ideally the ranges would be on sheet 2, and on sheet 1 there
would be a selection cell. When a range name was selected from a drop-down
list the contents of that range would be retrieved from sheet 2 and displayed
on sheet 1.

Thanks.
 
F

Frank Kabel

Hi
if your selection dropdown is in cell A1 you could use (for a single
cell):
=INDIRECT(A1)
 
K

Ken G.

Yes. I've since worked this out myself using the indirect command (thanks
Debra) to select the range and then copy and paste.
 
Top