Resetting picture index number?

[Bobby]

Is it possible to reset or assign a different picture number to a
picture recently copied on a worksheet? I use excel 2003

Thank's ahead

 

[Bobby]

Is it possible to reset or assign a different picture number to a
picture recently copied on a worksheet? I use excel 2003

Thank's ahead

Forgot to mention, if this could be done with VBA and how.

 

[Tim Williams]

Are the pictures being pasted via VBA ?
If not, the "recently" might be a problem unless you want to select
the picture before running the macro.

Tim

 

[Bobby]

Are the pictures being pasted via VBA ?
If not, the "recently" might be a problem unless you want to select
the picture before running the macro.

Tim




- Show quoted text -

Yes Tim the picture are being pasted via VBA !

 

[Tim Williams]

Immediately after pasting the picture, you should be able to access it via

Activesheet.shapes(activesheet.shapes.count)

You can then set its Name property to whatever you need.

Tim

Are the pictures being pasted via VBA ?
If not, the "recently" might be a problem unless you want to select
the picture before running the macro.

Tim




- Show quoted text -

Yes Tim the picture are being pasted via VBA !

 

[Bobby]

Immediately after pasting the picture, you should be able to access it via

Activesheet.shapes(activesheet.shapes.count)

You can then set its Name property to whatever you need.

Tim





Yes Tim the picture are being pasted via VBA !- Hide quoted text -

- Show quoted text -

Tim will sound simplistic, but I take a chance. If the picture name
is: picture 20 how do you rename it?
Is it: Activesheet.shapes("picture 20").name = Activesheet.shapes
("picture 40")

 

[Bobby]

Tim will sound simplistic, but I take a chance. If the picture name
is: picture 20 how do you rename it?
Is it: Activesheet.shapes("picture 20").name =  Activesheet.shapes
("picture 40")- Hide quoted text -

- Show quoted text -

Tim I did found out! Thank you again for your suggestion.