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
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
More like this?

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

Open in new window

0
 
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Yes exactly. Great answer! Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.