Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row and column headings
I have a macro that generates a csv file from a number of different csv
files. I would like to add a row and number each 1,2,3...... etc. These are going to be column headings in the csv file, which is then going to be imported into a database. I would like to be able to add this column and number it incrementally up for all columns containing data. For example; One spreadsheet might contain 7 columns of data therefore I would like to insert a row and insert the vaules 1-7. However the next spreadsheet might contain only 3 columns of data therefore I would like the macro to insert a row and only populate the first 3 cells with 1-3. Is this possible? Thanks Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row and column headings
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
How do I insert column headings above the numbered rows? | New Users to Excel | |||
how do I insert column headings or labels without using a row? | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |