Hi Darin

something along the following lines

Sub testvisible()
If Rows(7).Hidden = True Then
MsgBox "hidden"
Else
MsgBox "not hidden"
End If
End Sub

Cheers
JulieD

"Darin Kramer" wrote in message
...
Howdie...

Is it possible to write a formulae to tell whether a row a7 in this eg,
is visible or not?

I hide it or unhide it depending on what a user selects.

I know want to run something else depending if it is hidden or not...
and the user needs to be able to alter his choice....

Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!