Hi Team,
I want to find exact match while Running Macro, and while saving ACTIVE workbook I want find function back to Partial Match.
what is the correct way to do that.
End Sub
I want to find exact match while Running Macro, and while saving ACTIVE workbook I want find function back to Partial Match.
what is the correct way to do that.
VBA Code:
Sub test()
Dim FoundItem As Range
On Error Resume Next
Set FoundItem = Range("A2:a5").Find("Chicago", LookIn:=xlValues, LookAt:=xlWhole)
Set FoundItem = Range("A2:a5").Find("xyz", LookIn:=xlValues, LookAt:=xlPart)
On Error GoTo 0
Activeworkbook.saveas thisworkbook.path & "\" & "xyz.xlsx"
end sub
End Sub