Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an if statement that if range name "tax_r" = true then column E should
be hidden. I believe that there is a problem with my code and I can't see it. Private Sub Enter_Click() Worksheets("Intro").Visible = False Sheet3.Activate frm_Data.Show vbModeless Dim TaxType As String With Worksheets("vlookup") TaxType = .Range("Tax_r").Value End With If TaxType = "TRUE" Then Columns("E:E").Select Selection.EntireColumn.Hidden = True Range("A2").Select End If End Sub Can someone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Statement not working | Excel Worksheet Functions | |||
IF Statement not working | Excel Worksheet Functions | |||
If statement working only once | Excel Worksheet Functions | |||
If Statement Not Working | Excel Worksheet Functions | |||
IF statement not working | Excel Discussion (Misc queries) |