Private Sub UnhideAll()
Worksheets("Sheet1").Rows("1:100").Select
Selection.EntireRow.Hidden = False
st.Select
End Sub
public sub DG ()
Dim st As Range
Set st = Range("a1")
end sub
Basically this is my code and I want to call st which is in public to private UnhideAll sub procedure. However it wouldn't let me unless i set st in UnhideAll procedure. runtime error '424'
How can I access public variables from private?
Worksheets("Sheet1").Rows("1:100").Select
Selection.EntireRow.Hidden = False
st.Select
End Sub
public sub DG ()
Dim st As Range
Set st = Range("a1")
end sub
Basically this is my code and I want to call st which is in public to private UnhideAll sub procedure. However it wouldn't let me unless i set st in UnhideAll procedure. runtime error '424'
How can I access public variables from private?