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]