This part of a code threw an odd anomoly when updating a record. It was because this apparently searches the whole used range
How can I restrict the search to used rows in column A only
Any help appreciated![]()
lRow = .UsedRange.Find(What:=Me.MP1CPCtxt_2, After:=.Range("a1"), LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Row MsgBox lRow
Bookmarks