Could someone please tell me how I can vertically number the cells in Column B? I have some occupied cells at the top and want to begin #1 on about the 7th line. Please tell me there's an automatic way to do this while keeping the #s in Column A as they are.
Last edited by VBA Noob; 02-26-2008 at 02:24 PM.
Hi,
Do you mean you want to automatically number column B from B7 starting at 1 and increment downwards by 1? Take a look here - "Using Static Numbering"
http://www.bettersolutions.com/excel...I216582021.htm
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
YES! That's exactly what I was looking for! Thanks so much for your help.Originally Posted by oldchippy
I like the easy one's the best - thanks for the feedback
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks