Help! I am recording a macro and here is my delema: I need to add a1 and a2 to get totals. I record the macro and lets say data only goes up to row 10. The macro stops at row 10. Problem is that I export data to this workbook and it coulb be more that 10 rows! but my macro only goes to ten. Is there a way to tell it (formula)if there is data sum it.
Your help will be greatly appreciated!!
Let me start over I need to put a formula in j2 that will sum o22 the 022 will have different data all the time (sometimes it call go all the way to row 10 or row 100 I need a formula on j2 that can sum those three columns all the time. I am creating a macro.
This message was edited by Rick DeLa on 2002-05-08 15:49
Your help will be greatly appreciated!!
Let me start over I need to put a formula in j2 that will sum o22 the 022 will have different data all the time (sometimes it call go all the way to row 10 or row 100 I need a formula on j2 that can sum those three columns all the time. I am creating a macro.
This message was edited by Rick DeLa on 2002-05-08 15:49