Using Sum with range cell-variable referencing

Howdy ya'll,

So, I have created a macro that upon importing a script (I work at a polling firm) as text file formats the file in a particular way. I thought I had finished this project, but my colleague informed that it isn't helpful when a call goes on for multiple days.

I believe there are three major tasks with the next step.

First, create a total cell. In other words, when there is a row with "Total" in it, I need to Sum those cells from D to L and place the value in M column.
Second, total all the responses (these vary) across the different days.
Third, using the totals create column segments that represent that data as a percentage.

I have been fiddling around with my totals row, and found a few examples but it doesn't seem to work for me. The code I have been trying is in bolded red.



The code is below.

Please Login or Register  to view this content.

The first way gives me a wrong number of arguments or invalid property error.

This is a second way I tried:

Please Login or Register  to view this content.

Gives me essentially a range global failure error.

I also tried this, based on a stack overflow forum post.

Please Login or Register  to view this content.

This way just freaks out.

I have just now tried:

Please Login or Register  to view this content.

This doesn't give me a debug error message, but it does give me a formula error message of #NAME?. So, I know I am onto something. I just can't figure out the right combination of range(cell(row,col index) commentary to get it to work.

I have been up and down the forums and also in my Walkenbach Excel 2010 book, but cannot seem to find anything that actually works.


Help finding the correct formulation would be fabulous. Also, if anyone has best practices for how to sum the other rows with varied number of responses and lack of key words that would be awesome too.

Thanks in advance for any and all insight!

Rachelle

Hi rko,

Try it this way:

Please Login or Register  to view this content.

Hi rkorinko,

You're welcome and thanks for the rep!

That's easily fixed:

Please Login or Register  to view this content.

Or -just throw Calculate in as a command wherever you need it

* The resize changes the size of the range, in this case to 1 row and three columns

it's like saying

Please Login or Register  to view this content.