Show me what you mean in a sample workbook created from the macro and with the stuff manually added that you want.
Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.
Here it is. I did the calculation two ways. Now that I think about it, the second way is probably best as you don't need to know the depth of rows above you and the formula can be the same on each page.
Bookmarks