Find the first cell that matches criteria

[brites]

Hi,
I have an Ascending ordered column. How can I make a mcro to use as reference the first row that matches my criteria? (I want to know in which row "conclued" starts and finishes)

THANKS!

 

[DonkeyOte]

a few ways, one way would be utilising native XL match formula

assuming lookup criteria is in column A of Sheet1, x marks the spot...(ie row number in column A)

x = Application.WorksheetFunction.Match("concluded",Sheets("Sheet1").Columns(1),0)

note: you will need an error handler also in case you don't find a match... else VBA will bug out

 

[brites]

Perfect!!!
If I may... and to find the last one?

Thanks!