let us be very patient, & waiting for some one who give a formula that can write a Constat_Date into a cell
On Mon, Mar 14, 2011 at 1:06 AM, Hems <coolh...@gmail.com> wrote: > Hey STDEV(i), > > Thanks a lot but i dont want macro, i want formula for it. > > Let me know if is there any formula for this. > > Regards, > Hemant > > On Sun, Mar 13, 2011 at 1:04 PM, STDEV(i) <setiyowati.d...@gmail.com>wrote: > >> put this code into sheets' module >> >> Private Sub Worksheet_Change(ByVal Target As Range) >> ' siti Vi <villager.g...@gmail.com <villagera.g...@gmail.com>> >> ' jakarta, 11 mar 2011 >> '------------------------ >> If Target.Count = 1 Then >> If Target.Column = 1 Then >> If Target.Row > 1 Then >> If Len(Target) > 0 Then >> Target(1, 2) = Date >> End If >> End If >> End If >> End If >> End Sub >> >> >> >> On Sun, Mar 13, 2011 at 1:53 AM, Hems <coolh...@gmail.com> wrote: >> >>> Dear All, >>> >>> I want today's date in next column (column B) on the day when first >>> column ( column A) was updated. >>> for Ex. if A3 was updated on 14th Mar'11 then B3 should display that >>> date. If i open this file on 16th Mar'11 then also B3 should display 14th >>> Mar'11 and not 16th Mar'11. >>> >>> Appreciate i get formula for this issue rather then macro. >>> >>> >>> Thanks in advance >>> >>> Kind Regards, >>> Hemant >> >> -- ---------------------------------------------------------------------------------- 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/discussexcel