Having trouble with IF in VBA ...

Chris The Rock · Mar 15th, 2002, 03:15 PM

I want a message box to pop up IF the Column that the active cell is in is Hidden.

I tried this:
If ActiveCell.EntireColumnHidden = True Then

but I get "Object Doesn't support this property or method".

I suppose this is because I'm trying to describe the property of the cell rather than telling the program to change the cell's property.

Tom Urtis · Mar 15th, 2002, 03:31 PM

Here's what works when I try it:

Sub ColState()
If ActiveCell.EntireColumn.Hidden = True Then
MsgBox "Help, I'm lost!"
End If
End Sub

Mar 15th, 2002, 03:15 PM	#1
Chris The Rock Board Regular Join Date: Feb 2002 Location: Longmont, CO Posts: 279	I want a message box to pop up IF the Column that the active cell is in is Hidden. I tried this: If ActiveCell.EntireColumnHidden = True Then but I get "Object Doesn't support this property or method". I suppose this is because I'm trying to describe the property of the cell rather than telling the program to change the cell's property. __________________ "Never go in against a Sicilian when death is on the line!"

Mar 15th, 2002, 03:31 PM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,387	Here's what works when I try it: Sub ColState() If ActiveCell.EntireColumn.Hidden = True Then MsgBox "Help, I'm lost!" End If End Sub __________________ Tom Urtis Microsoft MVP - Excel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode