I have the month in a variable "mon1", the day in a variable "day1" , and the
year in a variable "year1". I need to use the find method to find this
specific date and here is the code I am using...
Set wks = ActiveSheet
Set rngSearch = wks.Cells
Set rngFound = rngSearch.Find("mon1 / day1 / year1")
Debug.Print rngFound.Address

This doesn't work. But if I use "4/1/2005" in place of the variables it
works just fine. What do I need to do to make this work? Thanks!!