Hello all,
Why does this not work?
I get "mismatch type" error
If I use
I get "object required" error
How do I pass a worksheet argument to a subroutine?
I am obviously not grasping something important about arguments in subroutines/functions
Why does this not work?
Code:
Sub generic()
Call Clear1("SlowDown")
End Sub
Sub Clear1(ByVal ws As Worksheet)
Workbook("Gap").Worksheet(ws).Activate
End Sub
I get "mismatch type" error
If I use
Code:
Call Clear1(SlowDown)
How do I pass a worksheet argument to a subroutine?
I am obviously not grasping something important about arguments in subroutines/functions