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?
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