LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DEE DEE is offline
external usenet poster
 
Posts: 250
Default Insert & Sequentially Number Column

Hi,
This is relatively simple, but I'm having a bit of trouble with it as I'm
not all that familiar with vba.

Objective:
Insert new column A, title it "Key", sequentially number from A2 to end of
data range in column a, i.e. 1, 2, 3, 4, etc.

Problem:
If column B contains empty cells, the numbering stops. I need it to keep
numbering until it truly reaches the end of the data range.

Thanks!

--
Thanks!

Dee
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel sequentially number each new document? Roland Excel Discussion (Misc queries) 1 March 4th 10 04:19 PM
How do I sequentially number indvidual worksheets? Soo Excel Worksheet Functions 2 September 3rd 09 03:26 PM
How do you number different items sequentially within a cell jamie james Excel Discussion (Misc queries) 0 August 7th 07 12:04 AM
How do I sequentially number every third page of my workbook? TNDeb Excel Worksheet Functions 1 October 25th 05 09:03 PM
How do I number pages of worksheets sequentially? jthecken Excel Discussion (Misc queries) 0 July 13th 05 05:06 PM


All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"