Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access to xls
if i have a pivot table
how can i search multiple values by the label so that i can populate a new spreadsheet ex you will notice in my 2 tables below that in my pivot table i don't have a column b but on my new table I do. How would i do this with code? pivot table a c d a 1 b 2 c 3 new table a b c d a 1 b 2 c 3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
access to xls
I am not quite sure where you are heading with the question but I think you
should be using the the ColumnRange property of a pivottable. Below is a way to list all the columns in the pivot table range. Note that there are title and Pivot value rows. Sub PrintPivotLabels Dim c As Object Debug.Print "There are " & ActiveSheet.PivotTables(1).ColumnRange.Cells.Count & " Columns" For Each c In ActiveSheet.PivotTables(1).ColumnRange Debug.Print c.Address & ":" & c.Value next C End Sub Good Luck -- Stewart Rogers DataSort Software, L.C. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I access the access data via Excel 2002 with auto update ? | Excel Programming | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
Access.Application.Quit - opens Access again then won't close - He | Excel Programming | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |