Hello, So I have a named range called "Hello" with dimensions C9F108.
I have another named range called "Hello1" with dimensions C112F211.
My worksheet for this is called WkshtBal.

For both of the named ranges, I want the sum of each column in the named range to appear in the row below the named range ( Row 109 for Hello) and in the same respective columns.

I then want to divide the sum of the columns of "Hello1" by the sum of columns of "Hello" to start at cell C7.

Anyone know how to do this in VBA Subroutine?