Hi,

I am trying to find a column heading within a worksheet and then delete
the entirecolumn. The following line of code does this fine but the
column I am trying to 'find' will not always be present. When the
column is not present this line of code will debug and I would like to
write something better than an 'On error' statement to proceed with the
code. I've been trying to put it in some kind of IF statement but
without success:

..Rows(1).Find("Myvalue").EntireColumn.Delete

I'm sure this is pretty simple but I'm having one of those days. Any
help, as always, would be much appreciated.

Thanks,

Adrian


--
Kobayashi
------------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...nfo&userid=871
View this thread: http://www.excelforum.com/showthread...hreadid=476777