Hello,
This is I guess a purely vba in Excel question, but I'm trying my luck here anyway. I've been trying to understand how to use the find method in vba to locate a row where Column A equals something and column B equals something else. I know that in my sheet this row will be unique and I'm trying to get this row number. I was only successful with getting it to work with locating the value in column A:
Would someone be able to show me how to exapnd this to search for that unique combination of col A and col B?
Thank you!!
This is I guess a purely vba in Excel question, but I'm trying my luck here anyway. I've been trying to understand how to use the find method in vba to locate a row where Column A equals something and column B equals something else. I know that in my sheet this row will be unique and I'm trying to get this row number. I was only successful with getting it to work with locating the value in column A:
PHP:
foundcell = Sheets("ZIP codes").Range("A1:A50000").Find(what:=ZipCode, _
LookIn:=xlValues, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)
ZipRow = foundcell.Row
Would someone be able to show me how to exapnd this to search for that unique combination of col A and col B?
Thank you!!