$$Excel-Macros$$ Re: Macro for word phrase recongnition count of them

May I know how duplicates are removing ?? as you have not wrote any command but still duplicates removed in this code. Vabz.. How ? Thanks in advance Mandeep Sub GetUniques() Dim d As Object, c As Variant, i As Long, lr As Long Set d = CreateObject(Scripting.Dictionary) lr =

Re: $$Excel-Macros$$ Fix the Shape

Welcome Eugene. Regards Ashish -- 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, like

Re: $$Excel-Macros$$ Re: Query on count

Thank you all. It's really helped me a lot. Thanks in once again On Thu, Nov 13, 2014 at 6:24 PM, Mandeep Baluja rockerna...@gmail.com wrote: Hey Kalyan, check this array formula and the sheet. =COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0)) Regards, Mandeep

Re: $$Excel-Macros$$ Re: Macro for word phrase recongnition count of them

Hi It uses VBA dictionary object, and good feature of it is that it does nit add duplicated record in it.!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 15, 2014 at 2:23 PM, Mandeep Baluja rockerna...@gmail.com wrote: May I know how

Re: $$Excel-Macros$$ Re: Fix the Shape

Hi You can add floating form with image!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 15, 2014 at 10:50 AM, Eugene Bernard eugene.bern...@gmail.com wrote: Thanks, I am, temporarily doing by this mehod only. regards Eugene On Sat, Nov

Re: $$Excel-Macros$$ Re: Fix the Shape

Hey Eugene, Check this... Pres alt + tab twice to type data in sheet will send form in background... When form is in background, press Ctr + Shft + U to close floating image... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 15, 2014 at 7:05

Re: $$Excel-Macros$$ Re: Fix the Shape

Hi Vaibhav Bhai, It's GREAT!!! Fantastic :) Regards Ashish -- 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

Re: $$Excel-Macros$$ Re: Fix the Shape

Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 15, 2014 at 8:42 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, It's GREAT!!! Fantastic :) Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

Can you explain it bit more with one example sample of 9 to 10 lines only... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 12, 2014 at 4:52 PM, Laxmanan M laxflyflow...@gmail.com wrote: Thanks vabz, How to achieve the second macro using

Re: $$Excel-Macros$$ Mark Pass/Fail using excel vba macro

Hi Vabz, i have done part of it and i need some amendments alone. 1) Macro for BG: It works fine. But there should be an additional condition. I won’t be able to explain it, but I will try to represent it on this picture. On this picture below all the lines should be OK, because there is

$$Excel-Macros$$ Need Help

To All:- PLease help me to provide formula to eliminate the space. Example file attached. Regards, *Imran Khan* -- 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 @

$$Excel-Macros$$ Need macro to copy data from excel file to another excel file

Hello, Awaiting for your reply. ...yudy -- 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

Re: $$Excel-Macros$$ Need Help

Used this Formula in D2 and drag down. . =SUBSTITUTE(A2, ,) Cheers On Nov 16, 2014 9:32 AM, Imran Khan ikha...@gmail.com wrote: To All:- PLease help me to provide formula to eliminate the space. Example file attached. Regards, *Imran Khan* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))