Selection problem to resize picture

**vismbr** · 09-14-2009, 02:42 AM

Hello, i'm new to Excel programming and need some help.

I'm trying to copy a picture from one Worksheet to another and then resize it, when i select the picture after pasting it into the other worksheet i use the code ActiveSheet.Shapes("Picture 6").Select, the problem here is that i don't know the name of the picture because i use a loop that copys alot of pictures.
How can i solve this ?

**Andy Pope** · 09-14-2009, 03:52 AM

Rather than using a name, that will likely change, use the counter.

Please Login or Register  to view this content.

**vismbr** · 09-14-2009, 04:30 AM

Thanks, worked perfectly!

I have another prolem that i just ran into, might aswell ask it now. How do i copy the source of a hyperlink ? I tried to record some macros but i dont get any code for going into the hyperlink options and copying the url.

**Andy Pope** · 09-14-2009, 05:08 AM

Start a new thread for your next question.

**jpc123** · 03-15-2013, 12:01 PM

Hi Vismbr,

will you please provide the full VB code for me? my email [email protected].
i was eagerly waiting for this kind of code since i am very poor at coding