how to count columns i pivot table?

  • Thread starter Thread starter ulfb
  • Start date Start date
U

ulfb

Hi
My pivot is dynamic, created with VB, and number of columns will vary.
I need this count in a variable for use in further processing.
Any assistance appreciated!
/ulf
 
Untested:

Sub aj()
myCol = ActiveSheet.PivotTables(1).TableRange2.Columns.Count
MsgBox myCol
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Unable to Group in Pivot Table 1
Excel 2010 Pivot Table 2
AutoFill down a certain number of rows 3
modified pivot table using a macro 2
Link Drop Down list with Pivot Table 3
Link Drop Down list with PIVOT Table in Excel 2003 0
Pivot table "Sum of" or "Count of" 1

Back
Top