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
|