Hello:

Is it possible to create a macro in Excel that will sum up a column of data,
rather than having the end user press the AutoSum button? I know it sounds
"lazy" on the user's part, but there is a good reason.

The situation is that an external application is going to be exporting data
to Excel, and the application can use Excel macros perfectly. I want to
create a macro in Excel that will automatically sum up a column of data
immediately after the data is exported to Excel.

Now, the number of records in that column is not going to be the same
everytime. I mean, the number of records one time might be 30, the next time
it might be 40, etc.?

Is this all possible to do in a macro?

Thanks!

childofthe1980s