Syntax?

[spacely]

Oh oh, what I do wrong?

I am on a sheet. On a second sheet I want to define a range, and do a search in that range...

Set c = Worksheets("CONFIGURATIONS").Range("A2", Cells(ActiveCell.End(xlDown).Row, ActiveCell.End(xlToRight).Column)).Find(Worksheets(ActiveSheet.name).Cells(1, Worksheets(ActiveSheet.name).Range("B1").Value).Value, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=True, SearchFormat:=False)

I believe the Range can have 3 arguments like that...

Dave

 

[shg]

I would split that statement into several statements so it's debuggable.