Edmond
02-19-2019, 10:10 AM
Hi Everyone,
It may seem trivial but I don't know a lot about Public Sub.
As I am working on multiple sub at a time I was wondering if I could set up all the variable in one sub.
Which led me to that code (doesn't work):
Public ws As Worksheet
Sub Test()
Set ws = ActiveWorkbook.Worksheets("Sheet1")
End Sub
Sub Call_Test()
Debug.Print ws.Name
End Sub
When I run it, I have the Run-time error '91'.
Do you have any ideas of what I am doing wrong here?
Thanks a lot in advance!
It may seem trivial but I don't know a lot about Public Sub.
As I am working on multiple sub at a time I was wondering if I could set up all the variable in one sub.
Which led me to that code (doesn't work):
Public ws As Worksheet
Sub Test()
Set ws = ActiveWorkbook.Worksheets("Sheet1")
End Sub
Sub Call_Test()
Debug.Print ws.Name
End Sub
When I run it, I have the Run-time error '91'.
Do you have any ideas of what I am doing wrong here?
Thanks a lot in advance!