Here is my problem:

Ok, two more things. 1. How can I do autofill formulas for an entire row
based off of finding the word "Totals"

After I put in this - Dim r As Range
Set r = Columns("a").Find("Totals", , , xlWhole)
If Not r Is Nothing Then r.Offset(, 1).FormulaR1C1 = "=sum(r1c:r[-1]c)" I
want to be able to run the formula for Column F11 and autofill all the way
down 2 rows up from the row that I have "Total" on.

I have names in column A, values in Columns B, C, D, E, G, H, J, K, M and O.
I need formulas in columns F, I, L and N. I have filled in my formulas for
the row that has the word "Totals"
in it. The first row with values in it is 11.

Please help!

--
Message posted via http://www.officekb.com