Vba Cellsfind Error 91. To identify where the error lies, you would need to STEP. You will see a VBA Editor window, seen in the screenshot below: Sample Macro Code.
Dim rngFind As Range, deleterow As Long. Before calling object members, verify that the. Can someone please tell me what I'm doing wrong.
Find(What:="hobbs", After:=ActiveCell, LookIn:=xlFormulas I'm fairly new to VBA, so now I just have to work out why your two solutions work!
You cand replicate your problem into a standard module and you can paste the entire code here.
Find row with Hobbs On Error Resume Next Cells. Before calling object members, verify that the. I am programming in VBA with ArcObjects.