ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Selecting last pasted object (https://www.excelbanter.com/excel-programming/387895-selecting-last-pasted-object.html)

avi

Selecting last pasted object
 
Hello,

I am building an application that involves some PowerPoint
manipulation fron Excel VBA.

When i paste a shape to PPT in Bitmap format (PasteSpecial), the shape
is not automatically selected as with other formats (quite stange
behaviour...). Is there a way to identify by code the lat pasted
object so i can select it accordingly?

Thanks a lot
Avi


Peter T

Selecting last pasted object
 
With Activesheet
..Shapes(.Shapes.count).select
End with

This selects the topmost object, typically the last inserted object. It
would select the last pasted object providing its order hasn't been changed
and no others inserted since.

Regards,
Peter

"avi" wrote in message
ps.com...
Hello,

I am building an application that involves some PowerPoint
manipulation fron Excel VBA.

When i paste a shape to PPT in Bitmap format (PasteSpecial), the shape
is not automatically selected as with other formats (quite stange
behaviour...). Is there a way to identify by code the lat pasted
object so i can select it accordingly?

Thanks a lot
Avi





All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com