How do I declare these publicly:
[vba]'Set Variables
Dim WB As Workbook, Detail As Worksheet, Cust As Worksheet, Prod As Worksheet
Dim rngFind As Range, MyInput As String
Set WB = ActiveWorkbook
Set Detail = WB.ActiveSheet
[/vba]
How do I declare these publicly:
[vba]'Set Variables
Dim WB As Workbook, Detail As Worksheet, Cust As Worksheet, Prod As Worksheet
Dim rngFind As Range, MyInput As String
Set WB = ActiveWorkbook
Set Detail = WB.ActiveSheet
[/vba]
[vba]
Public WB As Workbook
Public Detail As Worksheet
'etc.
Sub MyMacro()
...
End SUb
[/vba]
Posting Permissions
Reply With Quote
