Hi
one way:
msgbox application.match("1-A54",Range("A1:A1000"),0)

or use the Find method (see VBA help for an example)

-----Original Message-----
Hi, I am trying to extract the row number of a cell with
a particular
value. For example, I have a cell with the value '1-A54'
in it, and I
am trying to get the row number where this value appear.
Can anybody
tell me how to write it in VBA? Thanks a lot.



*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.