<div>
Exactly what I needed. &nbsp;Thanks!
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts.<br />
<br />
I have a large spreadsheet and would like a macro that will delete any columns that have &quot;MOE&quot; in row 1, and shift the columns so that there aren't any blank columns.<br />
<br />
Also, the number of columns will vary on each spreadsheet that I will modify with this macro. &nbsp;<br />
<br />
Please let me know if any additional information is required.<br />
<br />
Thanks,<br />
Jerald
</div>
</div>


Hello Experts.

I have a large spreadsheet and would like a macro that will delete any columns that have "MOE" in row 1, and shift the columns so that there aren't any blank columns.

Also, the number of columns will vary on each spreadsheet that I will modify with this macro.  

Please let me know if any additional information is required.

Thanks,
Jerald

How do I delete a column in Excel based on a cell value?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.