Error# 11004, Unable to set the property error

S

Sam Santiago

I am programmatically generating a pivot chart. I am trying to turn off the subtotals, but attempting to set the subtotals generates an error. I have an Array of strings containing field names for the pivot chart and within the script debugger I can see that the oPivotField has a value that is a PivotField type. Even in the immediate windows accessing the subtotals property generates an error. Anyone run into this?

For Each sFieldName In aFieldList
iCounter = iCounter + 1

Set oPivotField = oPivotTable.PivotFields(sFieldName)
If Not (oPivotField Is Nothing) Then
oPivotField.Orientation = xlDataField
oPivotField.Position = iCounter
oPivotField.Subtotals(1) = False <*** Generates Error
End If
Next

Thanks,

Sam

--
_______________________________
Sam Santiago
(e-mail address removed)
http://www.SoftiTechture.com
_______________________________
 

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

Error 1004 3
Run Time Error '1004' 1
Run Time Error 1004 in Loop 0
Pivot Table Error 1
Adding Report Filters to Excel Pivot Tables via VB. 1
unable to set the Orientation property of the PivatField class 0
Unable to get the PivotFields property of the PivotTable Class 2
automatically run a macro everyday 6

Top