ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Positioning a graphical object (https://www.excelbanter.com/excel-programming/305157-re-positioning-graphical-object.html)

Tom Ogilvy

Positioning a graphical object
 
With ObjShape
.Top = Range("B2").Top
.Left = Range("B2").Left
End With

--
Regards,
Tom Ogilvy

"quartz" wrote in message
...
I have a graphical object on a sheet and it is selected.
How can I align this object so that the top left corner of the object is

exactly at the top left corner of cell "B2"?

My code so far:

Dim objShape As Shape
Set objShape = ActiveSheet.Shapes(strSnapShotName)
objShape.?????????

Thanks much in advance.





All times are GMT +1. The time now is 09:58 PM.

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