Hi,

This code will find and select all rows that contain M it will o
course find the first row that contains the letter m, im not sure ho
to get it to find only the row that contains a single character, hop
this gets you a little closer!

Simon

Dim rng As Range
Dim what As String
what = "M"

Set rng = ActiveSheet.UsedRange.Find(what)
Rows(rng.Row).selec

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27684