Find row number of text Totals in column A

[Wedne5day1te]

I need to find the row number of the text "Total" in column A. Note that there is also the text "Totals" in the rows above which should be ignored. Thanks for any help on this.

 

[Fluff]

How about

Sub FindTotal()
   Dim Fnd As Range
   Set Fnd = Range("A:A").find("total", , , xlWhole, , , False, , False)
   If Not Fnd Is Nothing Then MsgBox Fnd.Row
End Sub

 

[Peter_SSs]

.. or possibly this?
=MATCH("Total",A:A,0)

 

[Wedne5day1te]

Many thanks. Very helpful

 

[Peter_SSs]

Many thanks. Very helpful

Glad you got something that works for you. Thanks for letting us know.