Display MoreYour code is testing Column E.
I don't know how how you expect it to work. Once a cell in D has a value entered it would open the range, but what about entries into other cells in D?
The Change event will only run when an entry is made in D.
You need something like this
I indeed had a error in the initial code.
After some trail and error i got my inital setup working using the following.
Code
If Not Intersect(Target, Columns(4)) Is Nothing Then
If Target.Text = Blank Then
Columns("F").EntireColumn.Hidden = True
Else
Columns("F").EntireColumn.Hidden = False
End If
End If
However the method you suggested using "Target.value" also works. Thanks for the help!