Hi Guys,
This is really dumb of me but here goes...
I have a formula =WORKDAY(TODAY(),-1) which will give me 10 Apr 07 in C1of sheet1 today.
I am trying to find the cell in column A of sheet2 which has the date value equal to C1.
However, my below macro keeps telling me object variable not set at the last line.. can someone enlighten me why?
Code
Dim s1, s2 as worksheet
dim tdy as range
Dim today as long
set s1 = sheets("Sheet1")
set s2 = sheets("Sheet2")
today = s1.range("C1")
Set tdy = s2.range("A1:A65536").find(today, lookin:=xlvalues)
tdy.Activate
Display More
Cheers
Lloyd