Finding the last cell containing a ceratain string.

[Erik345]

So say you've got six rows. On the three first rows you have written "hi" and on the last three you have written bye.

How do you get the row number of the last cell that has the "hi" string? Is this even possible?

[watersev]

hi, Erik345, as you have not specified how you need to achieve that, here is a formula solution (array formula is used, upon entering confirmed with Ctrl+shift+Enter)

[Erik345]

Thanks! Though I need it in VBAscript..