Visible Row?

[Darin Kramer]

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!

 

[JulieD]

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

 

[Tom Ogilvy]

Sub XXX()
If Range("A7").EntireRow.Hidden Then
MsgBox "The row is hidden"
Else
MsgBox "the row is visible"
End If

End Sub

is a start. You don't say how a user is given a choice or how to determine
what the user's choice is.

 

[Darin Kramer]

Howdie...

Thanks... I put it into a VBA module, but where do I see the result....?

In a cell type =testvisible ??

Regards

D


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

 

[JulieD]

Hi Darin

choose in the workbook tools / macro / macros and click on testvisible and
choose run - a message box will be displayed.

I understood that you wanted to use this test inside some code you already
had ... rather than in a cell ... did i misunderstand?

Cheers
julieD