this may have been answered before but just need more clarification. So basically, I have a pivot table whose range varies. What I want to achieve is to copy the range then save it as a picture.
I have no problems saving it as a picture (using Excel extension scope), but find it very challenging on how to select the range/s.
I’ve read to use read ranges, select range, etc, so it adds to my confusion. Appreciate your feedback. Below is a sample of the pivot table/range I need to select.