[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 970
  • Last Modified:

Excel VBA Find the cell nearest to the top corner of an image

Hi

Is it possible using Excel VBA to find the cell nearest to the top left corner of an image
inserted on the sheet
0
Murray Brown
Asked:
Murray Brown
  • 2
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,

Do you mean ?

MsgBox Selection.TopLeftCell.Address

Open in new window


Regards
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi

No. I have several images that the user can drag around a sheet to design a report layout.
I need to use VBA to find the top left cell for each image
0
 
Rgonzo1971Commented:
More like this?

For Each shp In ActiveSheet.Shapes
MsgBox shp.TopLeftCell.Address
Next

Open in new window

0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Yes exactly. Great answer! Thanks very much
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now