you have to run through the shapes collection
VB Code:
Sub shapes() Dim s As Shape For Each Shape In Sheet4.shapes 'use whatever sheet reference If s.Name = gcell Then MsgBox "shape exists" Exit For Next End Sub
|
Results 1 to 4 of 4
Threaded View
|
Click Here to Expand Forum to Full Width |