PC Review


Reply
Thread Tools Rate Thread

Auto fill Row Numbers in Col A

 
 
=?Utf-8?B?U0lUQ0ZhblRO?=
Guest
Posts: n/a
 
      9th Nov 2006
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 With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      9th Nov 2006
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.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-fill numbers in groups of 4 vtrud Microsoft Excel Misc 9 25th Sep 2009 09:23 PM
Auto fill numbers and text karchivese Microsoft Excel Misc 1 25th Jan 2008 07:23 PM
Auto fill numbers starting with zero pianogirlny Microsoft Excel Misc 3 31st Dec 2007 03:15 PM
How do I get auto fill to do decending numbers in a column? =?Utf-8?B?b2VzcXVlZW4=?= Microsoft Excel Misc 2 26th Jan 2005 02:55 PM
Re: Auto fill numbers David McRitchie Microsoft Excel Misc 0 21st Mar 2004 10:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:03 PM.