I have successfully run multiple macros in separate sub routines but I am now trying to run a macro (in the same workbook) at the end of another macro with code.
here is an abridged version of the code
Option Explicit
Sub Big_Macro()
Dim rData As Range
Dim lNextRw As Long
'I have deleted my steps 1 & 2 in the code (they work)
' Step 3 clear Update Results Form
Sheets("Update Results").Select
Range("G10:I21").Select
Selection.ClearContents
Range("i51:I62").Select
Selection.ClearContents
Range("F5").Activate
Selection.ClearContents
Range("c1").Select
'Step 4 run the update results macro
Call Other_macro
End Sub
Can someone advise what I am doing wrong with the last command to Call the other macro. I tried AplicationRun but that didn't work.
Any assistance is greatly appreciated.
Mike
Bookmarks