Hi All
I am declaring a two public variables at module level and wish to use SET Statement.
I am trying to use SET statement at module level / this work book level but i get a error message stating invalid outside procedure
My Query where can i set the value so that i can use WB1/WS1 across different sheets / procedures
[/CODE]
Public wb1 As Workbook
Public ws1 As Worksheet
Set wb1 = ThisWorkbook
Set ws1 = wb1.Sheets("Sheet2")
[/CODE]
Bookmarks