| 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 | |||
Hybrid Mode
