Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TxMarine1014

    Problem with Running Two Loop statements within the same Macro

    There was no code there when I used that opition
  2. TxMarine1014

    Problem with Running Two Loop statements within the same Macro

    Mintjulep....it will always have data in it. Jges....The Macro resides in the "LMP Exception Report.xlsm" report
  3. TxMarine1014

    Problem with Running Two Loop statements within the same Macro

    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...
  4. TxMarine1014

    Problem with Running Two Loop statements within the same Macro

    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...
  5. TxMarine1014

    VBA Case Error

    Thank you I was not aware of this forum I will go ahead and post there
  6. TxMarine1014

    Problem with Running Two Loop statements within the same Macro

    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...
  7. TxMarine1014

    VBA Case Error

    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() ' '...
  8. TxMarine1014

    VBA Case Error

    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...

Part and Inventory Search

Back
Top