Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if cell is hidden
I am in a for loop and want to do this
For Each Cell In Target If (the current cell in this for loop is hidden) Then true part Else not tru part End If Next how do I write (the current cell in this for loop is hidden) conditional. I want to find out if Cell, or Cell.Column is hidden, either one will work. As always thank you in advance for the help, it is appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if cell is hidden
Try this
Sub test() Dim cell As Range For Each cell In Range("A1:A10") If cell.EntireRow.Hidden = True Then MsgBox "Hidden" Else MsgBox "not Hidden" End If Next End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Wandering Mage" <Wandering wrote in message ... I am in a for loop and want to do this For Each Cell In Target If (the current cell in this for loop is hidden) Then true part Else not tru part End If Next how do I write (the current cell in this for loop is hidden) conditional. I want to find out if Cell, or Cell.Column is hidden, either one will work. As always thank you in advance for the help, it is appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if cell is hidden
Thank you! That is what I believe I was looking for, only I will use it for
column. "Ron de Bruin" wrote: Try this Sub test() Dim cell As Range For Each cell In Range("A1:A10") If cell.EntireRow.Hidden = True Then MsgBox "Hidden" Else MsgBox "not Hidden" End If Next End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Wandering Mage" <Wandering wrote in message ... I am in a for loop and want to do this For Each Cell In Target If (the current cell in this for loop is hidden) Then true part Else not tru part End If Next how do I write (the current cell in this for loop is hidden) conditional. I want to find out if Cell, or Cell.Column is hidden, either one will work. As always thank you in advance for the help, it is appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Hidden Check Box | Excel Discussion (Misc queries) | |||
Check status row (hidden or visible)? | Excel Programming |