Delete column if specific value is exist in same column

[bhandari]

We have a Data Validation list In A1 cell (ADD,REMOVE)

if the cell value is is "ADD" then do nothing
if the cell value is "REMOVE" then delete entire column

similar to "B" Column,"C" Column..etc

 

[Rick Rothstein]

LCol = Cells(3, Columns.Count).End(xlToLeft).Column
For C = LCol To 20 Step -1
    If Cells(19, C) = "REMOVE" Then Columns(C).Delete
  Next

This is the last and final question for you Rick Rothstein..
"SORRY FOR THE DISTURBANCE"

is it possible to start from column number 19 to 23 then 27 to 29(only this columns have "REMOVE") in cell

As long as the columns you want to skip will never contain the word "REMOVE" in them, my existing code should work fine for you (it only looks for the word "REMOVE" in Row 1, so if it is not there, nothing will happen to that column).

 

[bhandari]

just now realized. Many Thanks Rick Rothstein & Logit