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 Andrzejek 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
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
416
mintjulep
M
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
254
Andrzejek
Andrzejek
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
576
dhookom
dhookom
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
424
SkipVought
S
remeng
  • Locked
  • Question
Capture active macro name as a variable 1
Replies
16
Views
301
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top