| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
unhidden row
May I know how to number unhidden rows only
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
unhidden row
I never felt a need to do this but this should do it.
Sub numbervisiblerows() mc = 2'column number to check 2 is column B For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row If Rows(i).Hidden = False Then Cells(i, mc -1) = j j = j + 1 Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Nahc" wrote in message ... May I know how to number unhidden rows only |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
unhidden row
sorry sir, is there a simpler explanation ?
"Don Guillett" wrote: I never felt a need to do this but this should do it. Sub numbervisiblerows() mc = 2'column number to check 2 is column B For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row If Rows(i).Hidden = False Then Cells(i, mc -1) = j j = j + 1 Next i End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Nahc" wrote in message ... May I know how to number unhidden rows only |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhidden row only | Excel Discussion (Misc queries) | |||
| Copying only unhidden rows | Excel Discussion (Misc queries) | |||
| Print only unhidden rows | Excel Worksheet Functions | |||
| sumif only for unhidden rows | Excel Worksheet Functions | |||
| Protecting a worksheet so it cant be unhidden | Excel Discussion (Misc queries) | |||
Linear Mode
