View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TimT TimT is offline
external usenet poster
 
Posts: 69
Default If statement not working right

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?