ExcelBanter - View Single Post

[email protected]

wrote:
I have a macro that generates a csv file from a number of different spreadsheets. 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