View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jessica Jessica is offline
external usenet poster
 
Posts: 113
Default Deleting Columns Based upon Heading

I am writing a macro where I need to delete certain columns. I can write the
code to delete columns by the letter (i.e., if I want to delete column C).
However I want to delete a column based upon the heading.

For instance, I want to delete the column entitled "Bidder". I can write a
macro to find the header "Bidder", but I am not sure how to indicate that I
want the column that the active cell is in to be deleted.