Hello, I want to resize all pictures on a worksheet except for those in a specific range. Please could someone help with guidance on modifying the code below to achieve this?
Thank you,
Jess
![]()
Please Login or Register to view this content.
Hello, I want to resize all pictures on a worksheet except for those in a specific range. Please could someone help with guidance on modifying the code below to achieve this?
Thank you,
Jess
![]()
Please Login or Register to view this content.
Last edited by Brontosaurus; 05-16-2024 at 02:31 PM.
Perhab change range as needed A1:F10 is not to resize
![]()
Please Login or Register to view this content.
Last edited by daboho; 05-16-2024 at 08:44 AM.
![]()
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
Hi, thank you for your suggestion. The resizing only needs to take place on one worksheet so I modified your code to this;
But I get an error 91 - object variable or With block variable not set.![]()
Please Login or Register to view this content.
Can you help with what I did wrong?
Thank you
Apologies, this is the modified code;
![]()
Please Login or Register to view this content.
Last edited by AliGW; 05-16-2024 at 09:24 AM. Reason: Code tags added - please review the forum guidelines.
You should have added them to post #4, not duplicatied the post.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry, I dont understand your comment. I dont think I have duplicated the post
You did in order to add the code tags - you will see that I have deleted the duplicate and added code tags to the original post.
I dont know how I managed to do that but apologies. Does your involvement bring this thread to an informal conclusion or is it still active please?
No, of course not! The thread is still active.
Ok thanks. I realise what I did wrong now. Again, apologies
No worries.
Should be work only shape A2:B1000 to resize in every sheet
![]()
Please Login or Register to view this content.
Last edited by daboho; 05-16-2024 at 10:35 AM.
Just brilliant, thank you so much! I really appreciate your kindness, Jess
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks