Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

name of a pivotable on an active sheet 1

Status
Not open for further replies.
kingz2000

kingz2000

Programmer
May 28, 2002
304
0
0
DE

Hi,

since I create several sheets and on each a pivot table dynamically, how do I find out the name of a pivottable on a particular sheet. Say the sheet is 'active'?
 
Sort by date Sort by votes
A starting point:
ActiveSheet.PivotTables(1).Name

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote

thanx! I actually tried an index=0 but didn't think it would start with 1:)

thanx a lot.
 
Upvote 0 Downvote


This may also help DISCOVERING stuff...

faq707-4594

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
129
mintjulep
M
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
89
Andrzejek
Andrzejek
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
220
SkipVought
S
remeng
  • Locked
  • Question
Capture active macro name as a variable 1
Replies
16
Views
155
Andrzejek
Andrzejek
Katto
  • Locked
  • Question
VBA permutation of arrays
2
Replies
22
Views
229
Katto
Katto

Part and Inventory Search

Sponsor

Back
Top