in simplest form
Sub findcol()
mc = Rows(2).Find("a").Column
MsgBox mc
End Sub

--
Don Guillett
SalesAid Software

"Faby" wrote in message
ups.com...
How can I retrieve the column number of a cell in a specific row.
ie i want to get the column number of a cell in row 3 that holds the
value "successful" for instance
Thanks
Faby