If statement not working right
The problem is column E will not hide when the condition is met.
"TimT" wrote:
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?
|