IS there a way to find the name of GIF file over Excel cell

G

gggkkk

Please help, please!!!!

Is there a way to find the name of GIF image over a sheet cell. these
images are small tick marks and I need to store the count of these
images into each respective cell. There can be upto 3 GIF images at the
top left side of a cell.

Thanks
 
D

Dave Peterson

Over a specific cell?

You can cycle through all the pictures and look to see if it's floating over
that cell:

Option Explicit
Sub testme02()

Dim myPict As Picture
Dim myCell as Range

With ActiveSheet
set mycell = .range("L16")
For Each myPict In .Pictures
If Intersect(.Range(myPict.TopLeftCell, _
myPict.BottomRightCell), myCell) Is Nothing Then
'not over this cell
Else
MsgBox myPict.Name
End If
Next myPict
End With
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top