Forum Discussion

lillyg424's avatar
lillyg424
Copper Contributor
Dec 17, 2018

VBA

   My question now is what error is there in my code that it will not work with 2 different actions all in the same sub? They both work independently when I test them out, but I cannot figure out ho...
excel
Macros and VBA
JWR1138's avatar
JWR1138
Iron Contributor
Dec 17, 2018

Is it not he first occurrence of this line that's causing you issues?

 

If Intersect(Target, StatusTableRange) Is Nothing Then Exit Sub

 Could do:

 

If Intersect(Target, StatusTableRange) Is Nothing Then GoTo LabelName

And then add LabelName: before the 2nd half of your macro runs. 

  • lillyg424's avatar
    lillyg424
    Copper Contributor
    Dec 17, 2018

    Thank you so much, that worked!

    • JWR1138's avatar
      JWR1138
      Iron Contributor
      Dec 17, 2018

      Great.