Scenario:
I have a worksheet that has Column A and Column B, each containing 10
rows of data, that need to be added together and their sum displayed in
column C.

I want to copy this formula in Column C 10 rows down.

I want to write a macro that will do this but I want the macro to be
able to do the same operation in a file that would have any number or
rows to be added. I do not want to have this formula copied to all the
rows in Column C. Just the rows that have data to be added.

How would I code this?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/