VBA for MSProject

I am writing a macro for MSProject and have difficulty in finding a VBA instruction to read data in the existing project. Specifically I am searching for a specific activity name and then want to know which Row I am looking at:

Dim MyRow As Single
Find field:="Name", Test:="contains", Value:="End", _ Next:=True, MatchCase:=False
MyRow = ???????

Can anyone help out?

Mike