Auto fill Row Numbers in Col A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Macro to hide cols 2
Fill both cells if one cell has a negative amount 2
Auto format sheet 1
Column number of last column that returns value ignore formulas 8
apply next number in newly inserted row 2

Back
Top