Question moved from old thread: http://www.vbaexpress.com/forum/show...n-current-date
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Just found the solutuion still thank u P45CAL for your code.
Sub Ufa() Dim LastRrow As Long LastRrow = Attuale.Range("A" & Rows.Count).End(xlUp).Row x = CLng(Date) ActiveSheet.Range("A9:J" & LastRrow).AutoFilter Field:=9, Criteria1:=">=" & x, Operator:=xlAnd, Criteria2:="<" & x + 1 End Sub
Thank you Sam...sorry if I used an old thread....
It's OK.
In fact, old threads have been under discussion by the Moderators for a while now. We are all trying to figure out the best way to handle them for members.
What do you think?
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Thank you, yeah in fact is not an easy issue, becase for me I searched it and it was what I was looking for so I didn't thought of a new thread ...but yeah when it is so old it should be a new thread I think. The problem was that I wanted to give credit to P45CAL for the code and not put it as a new thread as a code of mine......but also to get the attention on that topic because as it was the code of P45CAL he would easly know the answer of my question and I thought I would have more possibilities of getting an asnwer .
I don't blame you, I probably would have done the same.
However the experts here mostly have jobs and often don't come by here for days and even weeks at a time. I'm retired and took up Programming as a hobby.
If you found the answer, you can mark your thread Solved with the Thread Tools link.
FYI, the difference between Date and NOW is that Date returns an integer, where Now returns a decimal number, Excel stores all dates and times as Doubles, then they are formatted for human consumption.
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
What you guys are doing is amazing......I just thank you all the time because you share information and you put your time in helping other people. I have been thankful lots of time to people like you and others who had helped me with my question. It is really amazing and admirable. THANK YOU SO MUCH FOR YOUR GREAT WORK.
Marked as Solved.