Excel 2000 programming problem

[alexschiefert]

hi!

how can i verify the number of a row in which an item is placed.

for example i have a worksheet with 1000 rows and the 74th item is "Hello".

now i want to save the row-number 74 to an array.

is there a "GetRow" command or something like that?

and how is it executed right?


please help me!


thx, alex

[BrianB]

This formula will find the row number (NB. counts first reference as 1)
=MATCH("Hello",A1:A5000,0)

If you are using VBA then use something like :-
Set c = Find(....
MyRow = c.row