| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function that returns if a given cell is visible or not in a filteredrange
I would like the IsVisible(A3) function that returns 1 for visible
or 0 for hidden. I am talking of a filtered range. Can anybody help? Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Function that returns if a given cell is visible or not in a filte
This should be fairly easy to write. Use the functionality
Function IsVisible(myRange as excel.range) as boolean IsVisible = False 'Ideas here only if myrange .count = 1 then IsVisible =not myrange.entirerow.hidden else 'what would you do if you entered more than one cell end if end function "vsoler" wrote: I would like the IsVisible(A3) function that returns 1 for visible or 0 for hidden. I am talking of a filtered range. Can anybody help? Thank you |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Function that returns if a given cell is visible or not in afilte
On 5 ago, 21:46, Barb Reinhardt
wrote: This should be fairly easy to write. * Use the functionality Function IsVisible(myRange as excel.range) as boolean IsVisible = False 'Ideas here only if myrange .count = 1 then * * IsVisible =not *myrange.entirerow.hidden else *'what would you do if you entered more than one cell end if end function "vsoler" wrote: I would like the * IsVisible(A3) *function that returns 1 for visible or 0 for hidden. I am talking of a filtered range. Can anybody help? Thank you I am going to try it. Thank you very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function that returns cell and or font color of another cell | Excel Programming | |||
| IF function which returns the text from a cell | Excel Worksheet Functions | |||
| Function that Returns address of that cell? | Excel Worksheet Functions | |||
| A function that returns the name of the current cell | Excel Discussion (Misc queries) | |||
| If function that returns value in a cell. | Excel Worksheet Functions | |||
![vsoler[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
