Hi i am having a problem with a variable
the variable is called data_to_find and is used several time in my excel workbook
i have declared it as public


Option Explicit
Public data_to_find As Variant
data_to_find = Date - 1

but when i run my code i get the error invalid outside proceedure

hope someone can help