Thread: delete columns based on value in one cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_943_] Simon Lloyd[_943_] is offline
external usenet poster
  
Posts: 1
Default delete columns based on value in one cell

You have mixed up your ranges, this work

Code
-------------------
If Cells(1, 254) = "123" The
Columns("A:D").EntireColumn.Delet
End I
-------------------

--
Simon Lloy

Regards
Simon Lloy
'The Code Cage' (http://www.thecodecage.com
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=3820

Reply With QuoteReply With Quote