<div>
try <a href="http://stackoverflow.com/questions/17549885/insert-new-column-in-table-excel-vba" rel="ugc">http://stackoverflow.com/questions/17549885/insert-new-column-in-table-excel-vba</a>
</div>


try http://stackoverflow.com/questions/17549885/insert-new-column-in-table-excel-vba [http://stackoverflow.com/questions/17549885/insert-new-column-in-table-excel-vba]

<div>
and<br />
<a href="http://www.mrexcel.com/forum/excel-questions/77371-visual-basic-applications-insert-row-colum.html" rel="ugc">http://www.mrexcel.com/forum/excel-questions/77371-visual-basic-applications-insert-row-colum.html</a>
</div>


and
http://www.mrexcel.com/forum/excel-questions/77371-visual-basic-applications-insert-row-colum.html [http://www.mrexcel.com/forum/excel-questions/77371-visual-basic-applications-insert-row-colum.html]

<div>
and<br />
<a href="http://answers.microsoft.com/en-us/office/forum/office_2010-excel/how-to-create-a-vba-to-add-and-delete-columns-in/b5435fc0-d061-49f5-b7af-eaeb926c83ca" rel="ugc nofollow">http://answers.microsoft.com/en-us/office/forum/office_2010-excel/how-to-create-a-vba-to-add-and-delete-columns-in/b5435fc0-d061-49f5-b7af-eaeb926c83ca</a>
</div>


and
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/how-to-create-a-vba-to-add-and-delete-columns-in/b5435fc0-d061-49f5-b7af-eaeb926c83ca [http://answers.microsoft.com/en-us/office/forum/office_2010-excel/how-to-create-a-vba-to-add-and-delete-columns-in/b5435fc0-d061-49f5-b7af-eaeb926c83ca]

<div>
<div class="content wysiwyg-content">
I have an Excel Spreadsheet with a lot of data. &nbsp; Some VBA runs and enters some analysis results into the cells in COL S. &nbsp;This works well, but sometimes the user forgets to make COL S the &quot;Test Results&quot; Column.<br />
<br />
How do I accomplish the following in my Excel VBA?<br />
<br />
If Column S, row 1 doesn't contain the text &quot;Test Results&quot;, I want to insert a new column &nbsp;at S and shift everything else right?<br />
<br />
Thanks!
</div>
</div>


I have an Excel Spreadsheet with a lot of data.   Some VBA runs and enters some analysis results into the cells in COL S.  This works well, but sometimes the user forgets to make COL S the "Test Results" Column.

How do I accomplish the following in my Excel VBA?

If Column S, row 1 doesn't contain the text "Test Results", I want to insert a new column  at S and shift everything else right?

Thanks!

Excel VBA - insert Column

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

Microsoft Excel

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.