Dim instance As Ovals
Dim i As Integer
Dim rng As Range
Set rng = Range("G5:G2000")
i = rng.instance.Count
MsgBox ("You have " & i & " errors")
End Sub
I am trying to put this at the end of a sub that is working. I get a run-time error 438 on the line "i = rng.instance.Count". Can anyone please tell me what I am doing wrong? I know just enough VBA to be dangerous .
Bookmarks