here is my code to find that cell is empty or has a picture in a specific cell (G10). I'm getting the error "Object variable or block variable not set". please help me !
Sub testFunction() Dim wShape As Shape Dim inputWks As Worksheet Set inputWks = Worksheets("membership Form") inputWks.Activate If wShape.TopLeftCell = inputWks.Range("$G$10") Then MsgBox "Image exists!" Else MsgBox "Image does not exist" End If End Sub
Bookmarks