I was trying to loop through all graphs on a sheet. I know tables and graphs are named with same prefix "CHXXXX" hence assumed getgraphs function would also apply to tables however it doesn't. What function should I use to get to tables?
Actually I just use default object ID so a pivot table is originally named as "CH1094" etc. I can probably use getsheetobjects() but assuming this will have unwanted items such as textbox, listbox etc.