I guess let me try to clarify what the problem really is. Both loops are seperate statements. However, when the second loop runs through to the bottom instead of returning to the beginning of the second loop it returns to the beginning of the program. The value of "n" seems to carry over fine...
Yes but I was under the impression after the first loop that I am reintializing it. Is this not the case? I included the portion of the Macro that was intended to do so below.
n = 1
Windows("Monthly Exception message report.xlsx").Activate
Do While Cells(2, n) <> Empty
If...
am running into another problem where I have two loops in my file, but for some reason at the bottom of the 2nd loop it jumps to the very beginning of the file, and not the beginning of the 2nd loop.
Sub MacroExceptionTotal()
'
' MacroExceptionTotal Macro
' This Macro will add the totals by...
Okay that helped! Thank you very much, but now I am running into another problem where I have two loops in my file, but for some reason at the bottom of the 2nd loop it jumps to the very beginning of the file, and not the beginning of the 2nd loop.
Sub MacroExceptionTotal()
'
'...
I am getting an error of Case without Select Case and I do not know why. I have used code similar to this in some previous Macros, so I would assume that it would work unfortunately it did not. Just a little background on to what I am trying to do:
I have two Worksheets that I am working with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.