| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Row Detection
Hi All
Is there a method using worksheet functions to detect if a row is hidden? I am using SUMIF(......) and want to place as part of the condition of summing whether a row is hidden or not. I can use Autofilter and Sub-Total to get this but I need more than one conditional. Cheers Nigel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hidden Row Detection
Try looking at this thread:
http://tinyurl.com/3ht7y -- Regards, Tom Ogilvy "Nigel" wrote in message ... Hi All Is there a method using worksheet functions to detect if a row is hidden? I am using SUMIF(......) and want to place as part of the condition of summing whether a row is hidden or not. I can use Autofilter and Sub-Total to get this but I need more than one conditional. Cheers Nigel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| key detection in user forms | Excel Discussion (Misc queries) | |||
| Color detection | Excel Worksheet Functions | |||
| add-in detection | Excel Programming | |||
| on press detection | Excel Programming | |||
| Detection of VBA code | Excel Programming | |||
![Nigel[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
