Simple way

If Range("A1").Value = "CLIENT" Then
Columns(1).Delete
ElseIf Range("B1").Value = "CLIENT" Then
Columns(2).Delete
ElseIf Range("C1").Value = "CLIENT" Then
Columns(3).Delete
End If



--
HTH

Bob Phillips

"Phil" wrote in message
...
Hi,

Can anyone tell me is it possible to delete a coulmn based upon what is
shown in a specific cell, I have a worksheet that in perhaps either A1 or
B1
or C1 the word CLIENT might appear, in whichever column the word appears I
want to delete that column, I can find lots on deleteing rows but nothing
on
deleting columns (is it similar?).

Thanks for the help, Phil