Re: $$Excel-Macros$$ get name of months from date

You can also format the cell Regards - Dave On 09/05/2011, at 9:17 AM, "STDEV(i)" wrote: > Unfortunately Month Function returns Month Index ( 1 to 12 ) not Month NAME > Assuming A1 containts date data : 12/31/2011 > Formula in B1 =MONTH(A1) returns : 12 not "December" > > In vba y

Re: $$Excel-Macros$$ get name of months from date

Unfortunately *Month Function* returns *Month Index ( 1 to 12 )* not *Month NAME* Assuming A1 containts date data : 12/31/2011 Formula in B1 =MONTH(A1) returns : *12* not *"December"* In vba you can used MonthName Function Sub AboutMonth() Range("B1") = Month(Range("A1")) Range("C1")

Re: $$Excel-Macros$$ Macro to monitor another Macro

Hey guys, its been 2 days but not even single reply. is it too tough or its not at all possible. i am not asking u to develop a macro n give it to me. just gimmi some hints to proceed. i hope this is fine with you guys.i m relying on you guys a lot. Thanks - Original Message > Fro

Re: $$Excel-Macros$$ get name of months from date

Use Month formula open excel and copy this in A1 04-04-2011 =month(A1) Thanks Nishant On Sun, May 8, 2011 at 4:48 PM, Rajesh K R wrote: > Hi Experts > If I want to get the name of month from dates > 1/4/11- April > 5/5/11 - May > > how I can I do it with a formula or code > > Regards

$$Excel-Macros$$ Excel Mobile Application Reader

Hey guys Can somebody tell me if there is a mobile application compatible with Sony Erricson W910i mobile phone that can open excel 2007 files. I have an excel document in my phone that i am failing to open even if i connect the phone to a computer I have attached the file below. Can somebod

Re: $$Excel-Macros$$ get name of months from date

assuming your date is in cell A2; also try this formula =TEXT(A2,"[$-6000446]") Punjabi month name ?? On Sun, May 8, 2011 at 6:18 PM, Rajesh K R wrote: > Hi Experts > If I want to get the name of month from  dates >  1/4/11    - April > 5/5/11   - May > > how I can I do it with a formula o

Re: $$Excel-Macros$$ Need Help

dear Mr. Verma, et us try both macros with the NEW source table (as New Input) like this please find attached: ** a workbook containing this data ** a workbook containing both macros X1 1.7 11/11/2008 01/11/2010 X2 2.4 11/12/2009 01/11/2010 X3 3.8 11/01/20

$$Excel-Macros$$ Have idea or suggestion for MS Excel ? Submit and win awesome prize

Dear Group members, An awesome opportunity to win prize and be closer to Microsoft Excel. What you need to do ? Just submit the idea or feature that you would like to implement in upcoming version of excel. http://www.google.com/moderator/#16/e=455db The best five ideas with maximum votes will

$$Excel-Macros$$ EQUITY MARKET Excel data from BSE website

http://www.bseindia.com/sprtvol/Missprtvol.asp http://goo.gl/kKhMN http://goo.gl/qy1LT Data sort to ascending order On May 8, 2:09 pm, Oza Nirav wrote: > *This formula is made for identify scrip from  INDIAN EQUITY MARKET > > Web based data extraction and sorting to % wise every five min

Re: $$Excel-Macros$$ get name of months from date

Use formula =text(ref,"Mmmm") Where ref is cell reference. BR// -Original Message- From: Rajesh K R Sender: excel-macros@googlegroups.com Date: Sun, 8 May 2011 16:48:36 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ get name of months from date Hi E

$$Excel-Macros$$ Access Problem

Hi Guys, Some time when i want to import any data in Access then i get an error "* is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.*" can Any one suggest me how to remove this error. Thanks Yogesh Gohil -- --

Re: $$Excel-Macros$$ =Now() Keep from changing

Agree with Stdv(i). On Sun, May 8, 2011 at 12:42 AM, Bob wrote: > If I enter the Customer in B27 I'd like for todays date to be entered > in F27 automatically. How would you keep the date from changing the > next day, each time the workbook is opened? Thanks in advance!!! > > -- > >

Re: $$Excel-Macros$$ Need Help

hi STDV(i) Your macro only working with 3 Rows.. if he want to add more data in that table it will not expend all table.. On Sun, May 8, 2011 at 1:40 PM, rajan verma wrote: > hi > find attached File > > > > On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com < > anvesh.gw...@gmail.com> wrote:

Re: $$Excel-Macros$$ Need Help

hi find attached File On Sat, May 7, 2011 at 11:33 AM, anvesh.gw...@gmail.com < anvesh.gw...@gmail.com> wrote: > Hi, > > I need help in VBA code. > I have excel sheet on which data is write as below mention > > > Input > > A BC D > 1 X1 1.51

Re: $$Excel-Macros$$ How to use Vlookup in macro

Dim LookUp_value as variant Dim LookupVector as range Dim ColNum as Integer Dim ans as Variant 'Assign the Values to Variables Ans=WorksheetFunction.Vlookup(Lookup_Value,Lookup_Vector,Colnum,0) On Sun, May 8, 2011 at 4:45 AM, STDEV(i) wrote: > It would be easy for anyone in the group to respo

$$Excel-Macros$$ Delete raws having data above the specified period

Hi Experts I need code to find the cells in column "A" having date above the date specified in "C1" then select the entire column and delete it. Then loop until all the data above the specified period deleted. Regards Rajesh Kainikkara -- --

Re: $$Excel-Macros$$ get name of months from date

Hi Thanks for the formula . Regards Rajesh Kainikkara On 5/8/11, ashish koul wrote: > =TEXT(a1,"") > > On Sun, May 8, 2011 at 4:48 PM, Rajesh K R > wrote: > >> Hi Experts >> If I want to get the name of month from dates >> 1/4/11- April >> 5/5/11 - May >> >> how I can I do it with

Re: $$Excel-Macros$$ get name of months from date

=TEXT(a1,"") On Sun, May 8, 2011 at 4:48 PM, Rajesh K R wrote: > Hi Experts > If I want to get the name of month from dates > 1/4/11- April > 5/5/11 - May > > how I can I do it with a formula or code > > Regards > > Rajesh Kainikkara > > -- > >

$$Excel-Macros$$ get name of months from date

Hi Experts If I want to get the name of month from dates 1/4/11- April 5/5/11 - May how I can I do it with a formula or code Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow u

Re: $$Excel-Macros$$ go back to the last visited page

Sub backward() If ActiveSheet.Index = 1 Then Exit Sub Else Sheets(ActiveSheet.Index - 1).Activate End If End Sub Sub forward() If ActiveSheet.Index = Sheets.Count Then Exit Sub Else Sheets(ActiveSheet.Index + 1).Activate End If End Sub On Sun, May 8, 20

$$Excel-Macros$$ go back to the last visited page

Hi Experts Is it possible to create two buttons one for forward & other for backward and move to sheets in the order what we used after login just like we do in a browser.Pls check the attachment Regards Rajesh Kainikkara . -- -