Good afternoon dear community,
I have this project I am blocking on where I need to hide/unhide 100+ named shapes with Excel. Shapes can also be duplicated.
I had no problem to do it with one (cf bellow code), but I am facing issues to create a loop with a range contained in one column. Attached, a simplified version for tests. Could you please support ?
Many thanks ahead for your help
Arnaud
Code I use for 1 named shape.
Please Login or Register to view this content.
Last edited by ploup; 07-10-2019 at 07:21 AM.
Hi & welcome to the board.
How aboutPlease Login or Register to view this content.
One way
Please Login or Register to view this content.
Change the sheet A2:An range as appropriate
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you both for your answer !
However, the one from Fluff13 is more appropriated thanks to the automatic maxed range and because he is not deleting the shape but hide/unhide them as per the request.
Again, thank you both for your time, it's highly appreciated. And big thanks to Fluff, it's even more appreciated
Case solved !
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks