You explained the logic in a precise and logical manner.I really appreciate your way of explaining.
So nice of you Mr.Paul. Thanks & Regards, C.G.Kumar On Wed, Oct 13, 2010 at 7:48 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > Let's examine what you're asking: > > (Now) returns the current date and time. > > Day(Now) returns the DAY portion of the current date and time. > > So, when I run this today (10/13/2010), Day(Now) returns 13. > > So.. the results of Day(Now) can ONLY be 1 to 31 (depending on the month) > it will NEVER be 0 > > Therefore, > If (Day(Now)) = 0 > will NEVER be true... > > > If you want it to run on the 13th day of each month, use: > > If (Day(Now) = 13) then > > (or change the 13 to whatever day of the month you wish to use) > > hope this helps, > > Paul > > > *From:* C.G.Kumar <kumar.bemlmum...@gmail.com> > *To:* excel-macros@googlegroups.com > *Cc:* villager.g...@gmail.com > *Sent:* Wed, October 13, 2010 2:22:17 AM > *Subject:* Re: $$Excel-Macros$$ Macro to run on specific day. > > i want to run this macro for today only , i am using following code but is > not working > > if (day(now) ) = 0 then > ' my code > end if > > Looking your comments ... > > On Wed, Oct 13, 2010 at 11:41 AM, siti Vi <villager.g...@gmail.com> wrote: > >> only work on day 5 to 10 of the month >> >> >> sub blablabla() >> >> if day(date) >= 5 and day(date) <=10 then >> >> * *your full macro* >> * >> end if >> >> end sub >> >> >> >> >> >> On Wed, Oct 13, 2010 at 12:26 PM, C.G.Kumar <kumar.bemlmum...@gmail.com> >> wrote: >> > Dear All, >> > I want my macro to be executed only for specific day in a month based on >> system date and it should not run thereafter. >> > Kindly let me know the code for it.It's urgent. >> > Regards, >> > C.G.Kumar >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > > > -- > Regards, > > C.G.Kumar > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Regards, C.G.Kumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
