Re: $$Excel-Macros$$ Charts in Excel

Dear Experts I want a help for charts. I wants to make a 3 charts in one graph,but problem is that the ranges are different for eg ranges are as follows range -1 =: 13 to 15 range -2 =: 19 to 22 range -1 =: 28 to 32 If i make all the charts in one graph then the scale will taken as from (min

Re: $$Excel-Macros$$ Need advise

Thanks Xls time, if i want to send mail using outlook will it work over there if so please can you help me out in this concern. On Mon, Mar 5, 2012 at 7:58 AM, xlstime wrote: > > use Google Insert Image option in G mail or you can use link a .gif > file... > [image: Inline image 1] > > > > >

$$Excel-Macros$$ Extract the numbers....

Dear Group, please help to extract the numbers in one cell to another through formula. Regards, Muneer, CC -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Extract the numbers....

Hi, Try it... =RIGHT(A1,LEN(A1)-FIND("-",A1,1)) Regards, MARIES. On Mon, Mar 5, 2012 at 2:47 PM, Mohammed Muneer wrote: > ** > Dear Group, > please help to extract the numbers in one cell to another > through formula. > > > Regards, > Muneer, > CC > > -- > FORUM RULES (9

RE: $$Excel-Macros$$ Extract the numbers....

Dear Maries, thanx for the help. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Monday, March 05, 2012 1:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Extract the numbers Hi

Re: $$Excel-Macros$$ Data saving problem

I'd like to help...just that I never understood your exact problem. I mean when I made a sample entry, it was fine (for first few columns). Can you send screen shots of your input (what you are entering in the form) and a sample output (what you want in which column) Regards, On Mon, Mar 5, 2012

$$Excel-Macros$$ custom number formating

7928688.conver this number using custom number format into 1000 mean i need custom number formating 7929 same goes with othe rnumber also. Date: Mon, 5 Mar 2012 16:49:27 +0530 Subject: $$Excel-Macros$$ Help On Chart From: shrinivas...@gmail.com To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Needle Gauge Chart

You can check in Name ranges. Here many name ranges are showing reference error.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: Mar/Thu/2012 09:02 To: excel-macros; David Grugeon Subject: $$Excel-Macros$$ Needle Gauge Cha

$$Excel-Macros$$ Split Number into multiple cell

Hi Ashish, could you plese tell me the formula for Spliting number into multiple cell appriciate fi you have vba code but it shouold be dynamics 12345 like 1 2 3 4 5 in multiple columnsa -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread title

RE: $$Excel-Macros$$ Need Urgent Help_Surendra

Try this : To get the list of file in selected folder : Option Compare Text Sub GetFileListFromFolder() Dim strFolderPath As String Dim objFso As Object Dim objFolder As Object Dim objFile As Object Dim lngICounter As Integer

RE: $$Excel-Macros$$ Kindly help me with my question on Excel

HI, Do you want this : Format : HH:MM:SS =TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())+20) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aruna jayaram Sent: Mar/Fri/2012 12:27 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Kindly h

Re: $$Excel-Macros$$ Split Number into multiple cell

Why not just use data>text to columns>fixed width>> Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: ICWAI Help Sent: Monday, March 05, 2012 7:58 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Split Number into multiple cell H

RE: $$Excel-Macros$$ Object Hyperlin : Deletion

Try this: Sub RemoveHyperLink() Dim shpShape As Shape For Each shpShape In ActiveSheet.Shapes shpShape.Hyperlink.Delete Next shpShape End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Mar/Fri/2012

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

Google is your friend. excel version differences Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Divaker Pandey Sent: Monday, March 05, 2012 8:53 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this q

Re: $$Excel-Macros$$ Hi Expert- please spend your few minute only on this question.

yeah, that is true. Google is our universal friend. but it will be awesome if group members got list of real time problem, or difference expert faces during use of different versions of excel. Divaker On Mon, Mar 5, 2012 at 8:43 PM, dguillett1 wrote: > Google is your friend. > > excel ve

RE: $$Excel-Macros$$ Split Number into multiple cell

=Transpose(Mid(A1,Row(Indirect("1:" & Len(A1"))),1)) with CSE -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ICWAI Help Sent: Mar/Mon/2012 07:28 To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Split Number into multiple cell

Re: $$Excel-Macros$$ Need advise

same. got to insert option then click picture option ..and select your image .. On Mon, Mar 5, 2012 at 3:13 PM, rekha siri wrote: > Thanks Xls time, if i want to send mail using outlook will it work over > there if so please can you > > help me out in this concern. > > > On Mon, Mar 5, 2012

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

Perfect, I wasn´t aware of that. Thank you very much. 2012/2/29 dguillett1 > range uses Range9(“a1:z21”) > cells uses cells(1,1) or cells(1,”a”) for Row first and column second. > result is the same > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Jorge Marques > *Sent

RE: $$Excel-Macros$$ Need advise

Hi Rekha, Outlook doesn't support animated GIFs. Hasn't for many years. They will just appear as a still image in Outlook, although they will probably still be animated for your mail recipients that use other mail clients, at least for web mail accounts. Alternatively you can send a video fi

Re: $$Excel-Macros$$ Need advise

Try : http://makeagif.com/ http://picasion.com/ On Tue, Mar 6, 2012 at 12:00 AM, Asa Rossoff wrote: > Hi Rekha, > > Outlook doesn't support animated GIFs. Hasn't for many years. They will > just appear as a still image in Outlook, although they will probably still > be animated for your m

Re: $$Excel-Macros$$ help

Hi Try : Sub Mtest() Dim i As Long Application.ScreenUpdating = False On Error Resume Next For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1 If InStr(1, Cells(i, 1).Value, "This page", 1) Or _ InStr(1, Cells(i, 1).Value, "Search Results", 1) Or _ InSt

$$Excel-Macros$$ GLOBAL COLLECTION

I want to work with Global Collections. I need to asociate IdProvider with NameIdProvider, but i don't want to use range because i need to use it in a function with a million records. And because i need to use this function in Ms Access as well. I would like to have a collection that, for each id

Re: $$Excel-Macros$$

Please Help & Urgent anybody pls forward me a employee database entery excel vba file On 3/3/12, Seran Senguttuvan. M.N wrote: > hai , > > any can forward me a employee database entery excel vba file > > -- > Regards > > > M.N.Seran Senguttuvan, > > -- > FORUM RULES (986+ members already BANNED f

$$Excel-Macros$$ copy range

Hi Guys/Girls i use VBA to copy a range using the following code Selection.AutoFilter Field:=7, Criteria1:="bob" ActiveSheet.Range("a1:o1", ActiveSheet.Range("a1").End(xlDown)).Select the problem that i have is in cell "G" after the last cell there is a 3 lines of blank cell and then the report,

$$Excel-Macros$$ how to subscribe?

Dear Friends, I want to subscribe this group with another mail id not Outlook - munnu130134...@gmail.com Can u please tell me how to subscribe? Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ how to subscribe?

Hi, Please find below link to join this group. http://groups.google.com/group/excel-macros On Mon, Mar 5, 2012 at 7:50 PM, Mohammed Muneer wrote: > Dear Friends, > > ** ** > > I want to subscribe this group with another mail id not Outlook – > munnu130134...@gmail.com > > ** ** >

RE: $$Excel-Macros$$ how to subscribe?

Mr. Seraj I try, this way last night but not working. Reply me Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Seraj Alam Sent: Tuesday, March 06, 2012 7:06 AM To: excel-macros@

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

For Negatives - (in F2 and drag down) - =SUMPRODUCT(($A$2:$A$27=E2)*($C$2:$C$27<0)*$C$2:$C$27) For Positives - (in G2 and drag down) - =SUMPRODUCT(($A$2:$A$27=E2)*($C$2:$C$27>0)*$C$2:$C$27) Attached. HTH Abhishek On Tue, Mar 6, 2012 at 10:26 AM, Ashish Bhalara wrote: > Dear expert, > > I nee

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

Dear Ashish, You can also try.. For Negative =SUMIFS($C$2:$C$27,$C$2:$C$27,"<"&0,$A$2:$A$27,$E2) For Positive =SUMIFS($C$2:$C$27,$C$2:$C$27,">"&0,$A$2:$A$27,$E2) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogs

Re: $$Excel-Macros$$ Conditional Sum by negative & positive value

My Try, For Negative, =SUM(IF(IF($A$2:$A$27=E2,$C$2:$C$27,0)<0,$C$2:$C$27,0)) For Positive, =SUM(IF(IF($A$2:$A$27=E2,$C$2:$C$27,0)>0,$C$2:$C$27,0)) Formula Apply with *CSE*. Regards, MARIES. +971502420957 On Tue, Mar 6, 2012 at 9:40 AM, NOORAIN ANSARI wrote: > Dear Ashish, > > You can also try

Re: $$Excel-Macros$$ GLOBAL COLLECTION

Dear Javivd, can you share a sample with group On Mon, Mar 5, 2012 at 5:38 AM, javivd wrote: > I want to work with Global Collections. > > I need to asociate IdProvider with NameIdProvider, but i don't want to > use range because i need to use it in a function with a million > records. And beca

RE: $$Excel-Macros$$ how to subscribe?

Thanx Noorain, I will try once and let u know. Regards, Muneer, CC... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Tuesday, March 06, 2012 8:34 AM To: excel-macros@googlegroups.com Subjec

$$Excel-Macros$$ Excel VBA Password protection

Dear Team Kindly let me know how to protect macro in Excel 2007 I want to lock the VBA so no one can step into it w/o the password -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formul

Re: $$Excel-Macros$$ Movie Collection Manager

Anyone...? On Thu, Mar 1, 2012 at 6:57 PM, Abhishek Jain wrote: > Hi friends, > > For the sake of learning I just keep doing some thing or the other, mostly > in excel. Once something occurred to me and this is what I have > accomplished so far - > > http://www.youtube.com/watch?v=-NT6IYrTqew > >