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