Ok, here is my objective. I have names in column A and totals in column B.
At the bottom of the excel sheet I have a cell titled "Totals". I want the
macro to be able to find the word totals, create borders for the entire sheet
and the run formulas in the "Totals" row for column B. I want the macro to
search out the first name in column A so the formulas for the Totals has
everything from column B. Hope that isn't confusing. Here is a diagram:

Column A Column B

name 98
name 97
name 89
name 64

Totals formula =SUM(B#:B#)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200605/1