Adding formulas to dynamic non-rectangle range

I have a very intricate and large data set that is dynamic (pulls charges for a large project per month and task). I need to add formulas using a macro to the set. I have done this easily for a rectangle shaped range. However, now I need to do it for a range that is not rectangle. There are two identifying factors (one in the rows and one in the columns) that I can use to define where to input the formulas but I don't know how to do this.

I was going to do the

Please Login or Register  to view this content.

loop to get some of it to work. I was going to do this from Planned Value down to the first month in column F. But then, I need do add the formula in the Total row (which is dynamic) all the way to column AZ. I don't know how to do this.

Here's my code right now, which puts it in F10:AZ200. However, I don't want the formula in the months after Planned Value for each task. So where I've put a red line around is where I want it. But the Total row can change and so can the Planned Value.

Please Login or Register  to view this content.

So how do I get it to put the formula from the first month to Planned Value, then down to Total, and across the Total row to AZ?

Thanks in advance.

Thanks so much, AlphaFrog. This looks great. However, I get the following error when I run it. Do you know why that might be? I have my code on the sheet specifically, not a module.

Hi AlphaFrog. I figured it out.

The "Planned Value" is put there through a formula, not as text. When I changed it to manual entry to test, everything worked fine. Is there a way around this?

The code right now for "Planned Value" is this

Please Login or Register  to view this content.

The code for "Total" is this

Please Login or Register  to view this content.

Thanks for your help.