Error In Finding Date In Another Range

tardy · 2007-04-11T11:18:19+01:00

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, 14 lines) Cheers Lloyd

tardy
Apr 11th 2007

tardy

Intermediate

Points

900

Posts

112
Apr 12th 2007
- #21
Re: Error In Finding Date In Another Range

Yes!

Will pay attention to overall design.. tks once again! : D
- 1
- 2Page 2 of 2

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Facebook
Twitter
Reddit
WhatsApp
LinkedIn
Pinterest
XING

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.

Participate now!

Share