Hi,
Is the file likely to be so small you can't see it?
One way would be
![]()
Dim shp As Shape For Each shp In ActiveSheet.Shapes If Not Intersect(Range("P7"), shp.TopLeftCell) Is Nothing Then MsgBox shp.Name & " is over cell P7" End If Next
Hi,
Is the file likely to be so small you can't see it?
One way would be
![]()
Dim shp As Shape For Each shp In ActiveSheet.Shapes If Not Intersect(Range("P7"), shp.TopLeftCell) Is Nothing Then MsgBox shp.Name & " is over cell P7" End If Next
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks