Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Numbering Macro
This simple piece of code will increment the first letter by 1 (AB etc),
for the selected range of cells. So after your insert, select all cells (in column A) after the inserted rows and run this code. Sub Recode() Dim c As Range For Each c In Selection If Len(Trim(c)) 0 Then c = Chr(Asc(Left(c, 1)) + 1) & Mid(c, 2, Len(c) - 1) Next End Sub -- Cheers Nigel "Sprinks" wrote in message ... We do conceptual cost estimating for architects at early stages of design in Excel. We use a standard of 60 lines per page with the following section conventions. Categories shown are just examples and vary, the # of lines vary since 2 or more categories may fit on a single page. What stays consistent is that after the last line of a category, there is a blank line followed by "Subtotal" in column B. ...header.... A Demolition A1 Stairs-on-grade 1 LS $1,500.00 1,500 A2 ... other line items A3 .... ... An Subtotal 20,000 ------------------------------------------------------------------------- B Foundations B1 ... Bn Subtotal Frequently, due to space limitations, we find it necessary to insert a new category, requiring that all subsequent categories need to be re-lettered, e.g., from B, B1-Bn to C, C1-Cn, n being the last line of the category. This is a tedious process that I'd like to automate. I can handle the inserting a new page but would like help with the relettering/renumbering. Can anyone point me in the right direction? Thank you. Sprinks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for sequential numbering. | Excel Discussion (Misc queries) | |||
auto numbering macro | Excel Programming | |||
auto numbering macro | Excel Discussion (Misc queries) | |||
auto numbering macro | Excel Worksheet Functions | |||
numbering macro | New Users to Excel |