Problem with Running Total Macro

Hello everyone,

I am relatively new to working with macros in excel and I am faced with a confusing problem.
I am using this macro from McGimpsey & Associates:

Please Login or Register  to view this content.

This works perfectly, but only in cell A1. I need it to work in cell H3, but when I change it to say:

Please Login or Register  to view this content.

then it does not do a running total in cell H3. Any ideas as to why this doesn't work?

Also, I would like to be able to run a few of these (one in H3 and one in H4) so how would I go about doing that?

Any help would be greatly appreciated.



Moderator note:

pls use code tags around your codes

Odd I tried your second code, and when I type something in H3, it does the total just fine...

In vba editor, top left, there should be a list of worksheets... Double click the sheet the macro should work in... That is where this code belongs, not in a regular sub

Also to work with 2 ranges, you'd need a second variable and if statement, something like:

Please Login or Register  to view this content.