software

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--
gggkkk
------------------------------------------------------------------------
gggkkk's Profile: www.excelforum.com/member.php...oamp;userid=29653
View this thread: www.excelforum.com/showthread...hreadid=493638Over 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(quot;L16quot;)
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
gggkkk wrote:
gt;
gt; Please help, please!!!!
gt;
gt; Is there a way to find the name of GIF image over a sheet cell. these
gt; images are small tick marks and I need to store the count of these
gt; images into each respective cell. There can be upto 3 GIF images at the
gt; top left side of a cell.
gt;
gt; Thanks
gt;
gt; --
gt; gggkkk
gt; ------------------------------------------------------------------------
gt; gggkkk's Profile: www.excelforum.com/member.php...oamp;userid=29653
gt; View this thread: www.excelforum.com/showthread...hreadid=493638

--

Dave Peterson