Function to return a range of cells from a PivotTable

[ubundom]

Excel2003 will not allow me to refer to another worksheet if I want to create
a Data Validation Settings: List.

I would like some help on how to return a range of data from a PivotTable. I
am familiar with the getpivotdata() function; is there a neat way of
collecting a range.

My thoughts are to create an array in a cell that might be used in the Data
Validation Settings: Source.

 

[Max]

Excel2003 will not allow me to refer to another worksheet if I want to
create

a Data Validation Settings: List.

But it does allow it, if you use a named range

Eg if you create a named range: MyR
which refers to, say: =Sheet1!$A$5:$A$7

you could then use it in a DV "List" in any other sheet
via setting Source: =MyR
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

 

[Shane Devenshire]

Hi,

You can name a range, by selecting it and then typing the name into the Name
Box on the left side of the Formula Bar, and pressing Enter.

Or you can choose Insert, Name, Define and type the name in the Names in
Workbook box (no spaces in names).

If this helps, please click the Yes button

Cheers,
Shane Devenshire