+ Reply to Thread
Results 1 to 7 of 7

Problem with Running Total Macro

  1. #1
    Registered User
    Join Date
    06-19-2015
    Location
    Michigan
    MS-Off Ver
    2010
    Posts
    30

    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
    Last edited by Fotis1991; 06-19-2015 at 01:06 PM. Reason: pls use code tags around your codes

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Problem with Running Total Macro

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

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    06-19-2015
    Location
    Michigan
    MS-Off Ver
    2010
    Posts
    30

    Re: Problem with Running Total Macro

    Now when I put either code into the Visual Basics editor it won't run the sub. It opens up the macro box but it doesn't let me choose a macro to run (there are none on the list). What am I doing wrong? I can't even test it at this point.

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Problem with Running Total Macro

    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

  5. #5
    Registered User
    Join Date
    06-19-2015
    Location
    Michigan
    MS-Off Ver
    2010
    Posts
    30

    Re: Problem with Running Total Macro

    In the Project VBA, in Microsoft Excel Objects -- Sheet1, I have pasted the code but it still does not work on my sheet. Clicking run does nothing, is there a step I'm missing?

  6. #6
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Problem with Running Total Macro

    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.

  7. #7
    Registered User
    Join Date
    06-19-2015
    Location
    Michigan
    MS-Off Ver
    2010
    Posts
    30

    Re: Problem with Running Total Macro

    Wow! I have no idea what changed but now the code works! Thank you so much, this helps a lot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] running total problem
    By loopiloo in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 06-10-2013, 12:01 PM
  2. invoicing problem, running total
    By bagelface in forum Excel General
    Replies: 0
    Last Post: 01-06-2011, 07:14 PM
  3. Need help with a running total macro
    By Onyx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2009, 11:54 PM
  4. Running Total problem
    By Cajun in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-21-2008, 04:36 PM
  5. Running Total Problem
    By mark.p.j in forum Excel General
    Replies: 3
    Last Post: 07-22-2005, 02:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1