Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto fill Row Numbers in Col A
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto fill Row Numbers in Col A
right click sheet tabview codecopy/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 "SITCFanTN" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-fill numbers in groups of 4 | Excel Discussion (Misc queries) | |||
Auto fill numbers and text | Excel Discussion (Misc queries) | |||
Auto fill numbers starting with zero | Excel Discussion (Misc queries) | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) |