Using Find method with Excel
I am using the following code to search for an item on an excel spreadsheet:
Set objValueFind = objSheet.UsedRange.Find(environment("TestName"))
However, when I do the search I want to match the full content of the cell. I looked at a couple resources (including this forum) and I found a method parameter called LookAt which I thought would help me do this but I keep getting a type mismatch error. Does anyone have an idea of what I am doing wrong? Here is the code:
Set objValueFind = objSheet.UsedRange.Find(theName, "LookAt:=xlWhole")
Re: Using Find method with Excel
Does anyone have more information about UsedRange.Find method?