ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need Macro to Find Column Heading -- if none, then insert new column (https://www.excelbanter.com/excel-programming/319011-need-macro-find-column-heading-if-none-then-insert-new-column.html)

Jeff[_43_]

Need Macro to Find Column Heading -- if none, then insert new column
 
Using Excel 2002 to manipulate an XML file and save as XLS file which
will be linked as a table to Microsoft Access. The issue is that the
XML file only shows table headings (i.e., column headings in Excel) if
there is data. If no data, then no heading.

Need a macro that will do the following:
1. Find column heading (e.g. "Scheduled Review Date") if exists, then
end the if statement.

2. If heading does not exist, then insert new column and label column
as "Scheduled Review Date".

Thanks for your help.



All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com