Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To find the column with its column heading | Excel Discussion (Misc queries) | |||
I want column heading non-scrolling and rows of each column scrol | New Users to Excel | |||
In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
How do I insert a heading into a column | Excel Worksheet Functions | |||
find row value, insert column | Excel Programming |