My spreadsheet contains all dynamic information that is either being
copied or created at runtime (objects). The user clicks and gets more
columns to put info in. They save in the end as a regular spreadsheet.
It's only one sheet.

When they "make" their sheet dynamically, it could resemble what i have
written beneath. There could be more or less columns but they are
repeated.

Row 14
TOTAL TOTAL
Row 15 Premium Taxes Premium Taxes Premium Taxes
PREMIUM TAXES
Row 16 250,000 12,000 17,000 1,000 30,000 3,000
=sum( =sum(

What I am looking to do is this. I want to build the formula as the
user builds the sheet. So if they build 3 Premium columns or 30
Premium columns, I want the formula to build based upon these values.

Currently, I am "finding" the values, using the ".find" functionality.
I search for the word "Premium" and then offset the row 1.
Offset(1,0).

My problem is that I assume I need to "loop" through the values in row
16 and include their addresses (not values) in the formula. Of course
the addresses would change.

I am a web programmer!!! This is my first Excel VBA project ever. I
have learned alot, but I really am terrible at it. The info I need now
is the very last "piece" of this solution. I have approx 4,500 lines
of code at this point created during my struggle. All is working well
except this logic.

Can anyone help? Thanks in advance if you can!