Jump to content
Macro Express Forums

Sledneck21

Members
  • Posts

    1
  • Joined

  • Last visited

Sledneck21's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hello, I've just converted a macro file from ME3 into MEP - The macro has an If statement that checks if a cell in excel is blank - if the cell is blank then the macro stops. If the variable is not blank then it continues with the rest of the code. And also a begining Repeat start for copying info from excel..see below - This code has been shortened and simplified.. Repeat Start (Repeat 9999 times) If variable %T7% = "" Macro Stop Else 'Do the rest of my proccess/code here, Which is several hundred lines long. code code code End If Repeat End The End If is at the very bottom of my code because if that cell(T7) is blank I need it to continue the process on the next line in excel. There is several other If statements and repeat starts/repeat ends in the remaining code but they all match up. - Including the first line of code with the initial repeat start of 9999 times..MEP isn't "seeing" the End If and the Repeat End at the bottom of all my code...But I can run the same macro/code in ME3 and there is no syntax errors or problems - the macro runs great. Is anyone else having problems once converting their macros to MEP and it not reading End Ifs or Repeat Ends? Any help/suggestions would be great. Thanks
×
×
  • Create New...