Search Function Macro not working

[skittlz]

I used VBA to record a "searching" macro, and posted it into my larger code - but it doesn't seem to be working.

    Set aCell = Sheets("DropDowns").Columns("J:K").Find(What:=Asset, After:="a1", LookIn:=xlFormulas2, _
        LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False)

currentSN = Trim(aCell.Offset(0, 1))
MsgBox currentSN

Basically - the macro is saying go to "Dropdowns" tab, search in Column J:K for a Asset (string), offset cells by 1 row and store value. I'm using MsgBox to verify it got the right value. I cant figure out why its not working - any ideas?

 

[MARK858]

Why would your After be

After:="a1"

When you are searching columns J and K?

 

[skittlz]

hah took me a while to figure out that silly error. Thanks!

 

[MARK858]

You're welcome