👀 Views: 1948 💬 Answers: 1 📅 Created: 2025-06-13

vba excel find VBA

I'm relatively new to this, so bear with me. I'm relatively new to this, so bear with me... I'm trying to locate a specific row in my Excel worksheet using the `.Find` method in VBA, but I'm encountering unexpected behavior when trying to use multiple criteria. My goal is to find a row where two conditions are met: the value in column A must match a specific name, and the value in column B must match a specific date. Here's the code I'm using: ```vba Dim ws As Worksheet Dim foundCell As Range Dim searchName As String Dim searchDate As Date searchName = "John Doe" searchDate = DateValue("2023-10-01") Set ws = ThisWorkbook.Sheets("Data") With ws Set foundCell = .Columns("A:B").Find(What:=searchName, LookIn:=xlValues, LookAt:=xlWhole) If Not foundCell Is Nothing Then If foundCell.Offset(0, 1).Value = searchDate Then MsgBox "Found at row: " & foundCell.Row Else MsgBox "Name found, but date does not match." End If Else MsgBox "Name not found." End If End With ``` When I run this code, I always get "Name not found." even though I can see entries for "John Doe" and the corresponding date in columns A and B. I've confirmed the data types and ensured there are no leading or trailing spaces in the cells. To troubleshoot, I inserted debug print statements, and I can see that the searchName and searchDate variables hold the expected values. I've also tried tweaking the `.Find` method parameters, such as `LookAt:=xlPart`, but that still doesn't yield the expected result. It seems like the `.Find` method is not functioning as intended for my use case. Is there something I'm missing in the approach or the configuration of the `.Find` method that prevents it from returning the expected cell? Any insights or alternative methods to achieve this would be greatly appreciated! This is part of a larger web app I'm building. Is there a better approach? Am I missing something obvious?