I'm new to "advanced" VBA macros and I'm having trouble. In general I
am trying to move through a spreadsheet, by column, making subtotals.
When my first formula is created, I move to the next line in the column
where I want the next formula. I am able to move to the areas I need
to, but I am having trouble writing the code to Sum the column up to
the last formula. The number of rows varies between formulas, so I am
trying to figure out how to tell excel to go to the previous formula,
move down one row and set that cell as the beginning range of the SUM
and then move to the bottom row above where the formula is and set that
active cell as the end of SUM range.

Any help is appreciated. Thanks.

Jim


---
Message posted from http://www.ExcelForum.com/