Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
providing serial numbers with cells hidden
It would help to know how (and when) you're putting in the serial numbers.
Before the data is entered? After? As each new row is added? Post the code that creates the numbers, if it's not too long. James "srinivasan" wrote in message ... Dear Community members, I am having a worksheet withlot of data with continuous serial number in col A. I would like to know if it is possible to provide continuous serial numbers without taking in to account of the rows that are hidden. i.e if row 5 is hidden the serial number should continue with row4 to row 6 without taking int o account of the hidden row 5 thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Serial Additions of Numbers Formatted "M-N" In Merged and Unmerged Cells | Excel Worksheet Functions | |||
drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
serial numbers with hidden rows | Excel Worksheet Functions | |||
to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Available serial numbers... | Excel Programming |