Re: $$Excel-Macros$$ Sharepoint

2013-12-16 Thread B.N.Chethan Kumar
Thanks it is working On Dec 16, 2013 1:45 AM, ashish koul koul.ash...@gmail.com wrote: try this

$$Excel-Macros$$ formula query

2013-12-16 Thread Rajesh Agarwal
-- *Rajesh Kumar Agarwal* *9811063001* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles,

RE: $$Excel-Macros$$ formula query

2013-12-16 Thread Ravinder
May be you r looking for this. =IF(AND(A9A8,A90),A9,B8) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajesh Agarwal Sent: Monday, December 16, 2013 4:01 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ formula query -- Rajesh

$$Excel-Macros$$ Replace text in chart data embedded in PowerPoint presentation - help, please!

2013-12-16 Thread Nirit
Hi all, I have a huge PowerPoint presentation, most slides with charts. I need to change the text within the charts - usually the text repeats itself in all charts. Instead of manually, opening the chart data and pasting the new text, I wrote the following syntax. All components work,

Re: $$Excel-Macros$$ how to crack Excel VBA password

2013-12-16 Thread nitin kumar
hello dear, i'm lost my excel file password i cant opne file so plz help string DPB is not found in hex editor nitin kumar On Saturday, February 20, 2010 10:08:47 AM UTC+5:30, cma.ankur wrote: plz send ur file Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone

Re: $$Excel-Macros$$ how to crack Excel VBA password

2013-12-16 Thread Kuldeep Singh
Pfb. http://stackoverflow.com/questions/11649064/excel-spreadsheet-password-cracking-using-vba -

Re: $$Excel-Macros$$ how to crack Excel VBA password

2013-12-16 Thread Kuldeep Singh
http://remove-vba-password.software.informer.com/ On Mon, Dec 16, 2013 at 7:49 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Pfb. http://stackoverflow.com/questions/11649064/excel-spreadsheet-password-cracking-using-vba

Re: $$Excel-Macros$$ Re: split and create two or more master sheets data into workbooks based on equal field

2013-12-16 Thread renuka chari
Dear sir, apart from this is there any alternative solution i mean any macro of this. please suggest thanks On Wednesday, 4 December 2013 09:40:53 UTC+5:30, Amit Desai (MERU) wrote: Dear Renuka, Please try “ASAP utilities” its free ADDIN for 90 days.. Regards, *Amit Desai *–

$$Excel-Macros$$ Re: Please provide the code for data entry as mentioned in excel

2013-12-16 Thread renuka chari
Thank you sir, i will check this once and tell you thanks once again On Thursday, 12 December 2013 22:24:33 UTC+5:30, pmyk wrote: Add these codes: [code] Private Sub UserForm_Click() Dim AlphaInSlNo As String Dim NumInSlNo As String Dim LenSLNo As Integer Dim NewSlNo As

$$Excel-Macros$$ sum numbers only

2013-12-16 Thread Satiqjaffar ali
Hello experts, Can you please assist me to sum numbers only in cell. Please find attachment and assist. Thanks in advance. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ sum numbers only

2013-12-16 Thread priti verma
Hi Satiqjaffar ali, Please try this With Control + Shift + enter =SUM(IFERROR(VALUE(IF(G16F17=$E$6:$E$12$F$6:$F$12,$G$6:$G$12,)),)) On Mon, Dec 16, 2013 at 9:46 AM, Satiqjaffar ali satiqjaffar...@gmail.comwrote: Hello experts, Can you please assist me to sum numbers only in cell. Please

Re: $$Excel-Macros$$ sum numbers only

2013-12-16 Thread Satiqjaffar ali
Hello Priti, Thanks for effort, and can you please explain the same with SUMIFS function.? On 16 December 2013 21:01, priti verma pritiverma1...@gmail.com wrote: Hi Satiqjaffar ali, Please try this With Control + Shift + enter

Re: $$Excel-Macros$$ how to crack Excel VBA password

2013-12-16 Thread nitin kumar
Sorry but its not working On Dec 17, 2013 1:39 AM, nitin kumar nitin.k...@gmail.com wrote: Sorry but its not working plz help On Dec 16, 2013 7:51 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: http://remove-vba-password.software.informer.com/ On Mon, Dec 16, 2013 at 7:49 PM, Kuldeep

Re: $$Excel-Macros$$ how to crack Excel VBA password

2013-12-16 Thread nitin kumar
Sorry but its not working plz help On Dec 16, 2013 7:51 PM, Kuldeep Singh naukrikuld...@gmail.com wrote: http://remove-vba-password.software.informer.com/ On Mon, Dec 16, 2013 at 7:49 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Pfb.

$$Excel-Macros$$ Find, move delete

2013-12-16 Thread Bill Q
Hi, The macro below currently finds and removes selected characters that it find. It works great. No issues. What I would like is this to be modified so that if it finds a character within the array - it will move the character in question to the adjacent cell to the right, THEN it will

$$Excel-Macros$$ Re: Find, move delete

2013-12-16 Thread Basole
Hi Bill, try this: Sub CLEARNUMBERS001() s = Array(+, -, .5, -.5, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9) For Each r In Selection v = r.Value ActiveCell.Offset(r, 1) = v For i = 0 To 13 v = Replace(v, s(i), ) Next r.Value = v Next End Sub regards, Basole Em segunda-feira, 16 de dezembro de 2013

$$Excel-Macros$$ formula query

2013-12-16 Thread Rajesh Agarwal
Yes. It is working fine. -- *Rajesh Kumar Agarwal* *9811063001* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

$$Excel-Macros$$ Re: Find, move delete

2013-12-16 Thread Bill Q
Besole, I get a type mismatch error on ActiveCell.Offset(r, 1) = v. On Monday, December 16, 2013 8:36:10 PM UTC-5, Basole wrote: Hi Bill, try this: Sub CLEARNUMBERS001() s = Array(+, -, .5, -.5, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9) For Each r In Selection v = r.Value