Function that returns if a given cell is visible or not in a filteredrange

V

vsoler

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
 
B

Barb Reinhardt

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
 
V

vsoler

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
Click to expand...

I am going to try it.

Thank you very much
 
Top