check if cell is hidden

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Thank you! That is what I believe I was looking for, only I will use it for
column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding cells in another worksheet 2
read hidden cells; vba 6
find out if cell is hidden in if statement 2
VB If statement Help 0
VBA set thick borders around non empty cells in range 0
Individual Character fonts in a cell 12
[Q] For, Next - How to Speed Up 6
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0

Back
Top