| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
providing serial numbers with cells hidden
I have posted an example to http://www.HelpExcel.com/examples
The title is hidden.xls I use a simple function to determine whether the row is hidden or not: Public Function hiddenRow() Application.Volatile True hiddenRow = Application.ThisCell.Rows.Hidden End Function -- http://HelpExcel.com "srinivasan" wrote: 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 |
| 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 | |||
| providing serial numbers with cells hidden | Excel Programming | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Threaded Mode
