I have a excel spreadsheet creating a pivot table. In my code I am trying to
select certain states to group, would anyone know how to write the code to
select the states other than those I ask it not to select. For example: I
have states TX, OK, AZ, CO, NV, CA, OR, TN, IN, etc. I want the "pivotselect"
to select all states except "TX, OK, CO, NV", now these 4 states will always
be excluded. As far as the rest of the states, there could be other states
coming in on different days.

Code Example: ActiveSheet.PivotTables("PivotTable2").PivotSelect
"STATE2['Not Like'AZ,CO,NV,OK,TX]", xlDataAndLabel