Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm new to macros, but not excel.
I have a pivottable, and want to write a macro to select specific, absolute names of people. I record the macro, and this is what it gives me: ActiveCell.Offset(20, -12).Range("A8,A6,A3,A1").Select ActiveCell.Offset(20, -12).Range("A1").Activate Selection.Group I want it to select a person's name instead, but the code is off, but I'm close...yet so far. Example like this may help.... With ActiveSheet.PivotTables("PivotTable20").PivotField s("LO Name (f451)2") .PivotItems("SMITH, JAMIE").Visible = False .PivotItems("BENJAMIN, CHERYL").Visible = False .PivotItems("TONIS, KEN").Visible = False In the active pivottable, I want to select these three names and group them. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I can not select Pivot Table on my Data Menu | Excel Discussion (Misc queries) | |||
macro sheet select | Excel Discussion (Misc queries) | |||
Pivot Table Report formatting - can't select Data Source Order | Excel Discussion (Misc queries) | |||
Spinner macro for Pivot Tables. | Excel Worksheet Functions | |||
Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions |