Trying to come up what a way to determine what my activecell is in; a Table, a PivotTable, a data range, or a shape. Whatever it's in will determine what my macro does next. I'm not finding much online except https://www.techrepublic.com/blog/mi...is-in-a-table/, which had a function that gave me hope, but doesn't seem to work. Any help would be appreciated.