Find PivotTable in Excel
-
Can someone help me with an If statement? I have one Excel sheet with gobs of data and several sheets thereafter with pivot tables. My code will eventually sequence through the various sheets and update the PivotTables. I can't figure out the command to determine if the sheet contains (and ultimately select a cell in) a PivotTable. TIA, Bomb_Shell (noob)
-
Can someone help me with an If statement? I have one Excel sheet with gobs of data and several sheets thereafter with pivot tables. My code will eventually sequence through the various sheets and update the PivotTables. I can't figure out the command to determine if the sheet contains (and ultimately select a cell in) a PivotTable. TIA, Bomb_Shell (noob)
AFAIK, Pivot tables are auto generated based on the data you selected for pivot in Excel. So, why are you changing the Pivot? Instead change the source data, Pivot table will automatically update itself.
"hi, I am explorer.exe. sometimes when you are doing anything at all, I will just freeze for ten minutes. All of my brother and sister windows will also freeze, because they are sad for me. Maybe we will come back, maybe not, it will be a surprise!"
-
Can someone help me with an If statement? I have one Excel sheet with gobs of data and several sheets thereafter with pivot tables. My code will eventually sequence through the various sheets and update the PivotTables. I can't figure out the command to determine if the sheet contains (and ultimately select a cell in) a PivotTable. TIA, Bomb_Shell (noob)
-
I think this is what you may be looking for: http://answers.yahoo.com/question/index?qid=20070918114411AAsehq7[^] (look at the last post in the list). I hope this helps.
That kind of helps. I was looking more for something like: If the active sheet has a pivot table <-- this is the part I'm stumped on. Then PivotCache.Refresh Bomb_Shell (noob)