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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

macro and pivot table

Status
Not open for further replies.
thelos

thelos

Technical User
Aug 1, 2005
17
GB
hi guys
in a macro i am writing at the momenent i am trying to tell a pivot table to use everthing on the page i cant use absolute reference because each workbook it will pivot is a different column depth there will always be 5 columns
thanks
 
Sort by date Sort by votes
How can I rename a table as it changes size" faq68-1331

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
330
mintjulep
M
remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
376
strongm
strongm
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
365
dhookom
dhookom
arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
152
arvarr
arvarr
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
212
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top