Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphical indicator | Excel Discussion (Misc queries) | |||
Graphical Representation | Excel Discussion (Misc queries) | |||
What is the deal with Comment Object Positioning? | Excel Discussion (Misc queries) | |||
graphical problems | Charts and Charting in Excel | |||
Graphical plan | Excel Programming |