RE: $$Excel-Macros$$ formula to add date in next column

2011-03-13 Thread Dave Bonallack
Hi Hemant, I don't think there's a non-macro solution for this. Regards - Dave. From: coolh...@gmail.com Date: Sun, 13 Mar 2011 23:36:21 +0530 Subject: Re: $$Excel-Macros$$ formula to add date in next column To: excel-macros@googlegroups.com Hey STDEV(i), Thanks a lot but i dont want macro,

Re: $$Excel-Macros$$ formula to add date in next column

2011-03-13 Thread Hems
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) wrote: > put this code into sheets' module > > Private Sub Worksheet_Change(ByVal Target As Range) >' siti Vi >

$$Excel-Macros$$

2011-03-13 Thread vijayajith VA
Hai excel gurus,, Can you mail me vlookup example in macros? if you dont mind i need code with excel sheets please!!11 Thankyou -- -- Some important links for excel users: 1. Follow us on TWITTE

Re: $$Excel-Macros$$ Re: Rename of files in specific format

2011-03-13 Thread Ankit
It's working... thanks alot ashish... you are rocking On Mar 11, 8:13 am, ashish koul wrote: > hi' > > see if it helps > > first click on get file names then type the new names manually in col  d and > run the rename macro > > > > > > On Tue, Mar 8, 2011 at 10:39 PM, Ankit wrote: > > Dear As

$$Excel-Macros$$ Macro for Editing link

2011-03-13 Thread Ankit
Guys need help in editing links of a worksheet with more than 100 links like this - Now excel file is in March'11 folder with below link- D:\F&F\Feb 11 - Circle\AA\GA - AA_F&F_FEB_2010-11.xlsx D:\F&F\Feb 11 - Circle\AB\GA - AB_F&F_FEB_2010-11.xlsx D:\F&F\Feb 11 - Circle\AA\Other Cost - AA_F&F_FEB

Re: $$Excel-Macros$$ formula to add date in next column

2011-03-13 Thread STDEV(i)
put this code into sheets' module Private Sub Worksheet_Change(ByVal Target As Range) ' siti Vi ' jakarta, 11 mar 2011 ' If Target.Count = 1 Then If Target.Column = 1 Then If Target.Row > 1 Then If Len(Target) > 0 Then