Posted: 17 Aug 2019 13:11 EDT Last activity: 26 Dec 2019 8:56 EST
Unable to get Range for Excel after filtering the data in it
I am trying to get the range of the visible cells in worksheet after filtering the values but unable to get the range. I have attached a sample automation where you can try for yourself and let me know if you found anything. I will update the post if I was able to get it.
I apologize for this going stale. I am looking at your sample solution, however it seems to rely on a specific Excel file as well as a few variables who's values are undefined. Would you please provide a little more details in addition to the instructions for getting this working? I'll be happy to take a look once you respond.