Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Visual Basic
how do I get the reference of the cell where a pictue/shape resides?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Visual Basic
Try something like the following:
Dim SH As Shape Set SH = ActiveSheet.Shapes("TheShape") Debug.Print SH.TopLeftCell.Address -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ecpl_3" wrote in message ... how do I get the reference of the cell where a pictue/shape resides? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
(ERROR) Microsoft Visual Basic: 400 | Excel Discussion (Misc queries) | |||
microsoft visual basic | Excel Programming | |||
Microsoft Visual Basic for Applications Extensibilty 5.3 | Excel Programming | |||
Help menu in Microsoft Visual Basic | Excel Programming |