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

  • Thread starter Thread starter vsoler
  • Start date Start date
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
 
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
 
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
 
Back
Top