Djblois
07-14-2006, 06:16 AM
How do I declare these publicly:
'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
'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