Is there a simple macro to add a row number in col A if there is text in Col
B. I've searched this site but haven't found anything similar? Thanks for
your help.

right click sheet tab>view code>copy/paste this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 2 Then Exit Sub
Target.Offset(, -1) = Target.Row

End Sub

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"SITCFanTN" <(E-Mail Removed)> wrote in message
news:BAA94C91-5992-43AC-898C-(E-Mail Removed)...
> Is there a simple macro to add a row number in col A if there is text in
> Col
> B. I've searched this site but haven't found anything similar? Thanks
> for
> your help.