Excel VBA one macro to run multiple macros not working

[Stuepef]

I want one macro to run several other macros, but when I write the code, I receive a compile error - sub or function not defined. What am I missing?

Sub Runallmacros()    
    Call LYRates
    Call TYRates
    Call DeleteSpaces
End Sub

 

[Stuepef]

like this? StopMacro1?

 

[Fluff]

No, like

Sub TyRates()
Stop
The rest of the code

 

[Stuepef]

Yes, the word stop is highlighted when I insert it into the TYRates module.

Sub TYRates()
Stop
   Dim Usdrws As Long
   
   Application.ScreenUpdating = False
   With Sheet13
      Usdrws = .Range("A" & Rows.Count).End(xlUp).Row
      .Range("A1").AutoFilter 1, "<>" & Sheet2.Range("AZ43").Value
      .Range("A2:A" & Usdrws).SpecialCells(xlVisible).EntireRow.Delete
      .Range("A1").AutoFilter
   End With
End Sub

 

[Fluff]

When Stop is highlighted, switch to sheet13 & then step through the code using F8, can you see the sheet getting filtered?

 

[Stuepef]

man I must need more coffee, the reason it was not working was because I had it filtered already for a different reason. Once unfiltered, it works fine. Sorry for the question!

 

[Fluff]

No worries & glad it's sorted.
Thanks for the feedback