Select dynamic range and save as picture

Hi all,

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.

What problems did you encounter with Select Range?

Hi @jcvsalinas ,

Below is the error.
select range

Before runnung the workflow, make sure that all Excel processes are ended in the task manager Exception HRESULT: 0x800AC472 (Excel out of scope)