PDA

View Full Version : Declare Publicly



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

Bob Phillips
07-14-2006, 06:28 AM
Public WB As Workbook
Public Detail As Worksheet
'etc.

Sub MyMacro()
...

End SUb