Re: $$Excel-Macros$$ Count If Cell Contains

Great Abhishek!. Regards, Prafull Jadhav 9920553518 On 8 September 2015 at 11:51, 'David Lanne' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> wrote: > Thank you very much > > > > On Tuesday, September 8, 2015 2:17 AM, Swapnil Palande < > palande

Re: $$Excel-Macros$$ How to protect only few cells

Dear Ashish, Great! You have given explanation Step by Step. Regards, Prafull Jadhav 9920553518 On 5 December 2014 at 17:13, Ashish Kumar kumar.ashish...@gmail.com wrote: Welcome Putta. -- 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

Re: $$Excel-Macros$$ Information

Dear Vaibhav Sir, You are really Great. You have solution for all queries. I am associate with this group since one year and learn lot of about VBA. Sir...if you are conducting VBA courses then please enrolled my name first. Keep it Sir. Thanks once again! Regards, Prafull Jadhav

Re: $$Excel-Macros$$ Re: VBA

Dear Paul Sir, Can you please explain what is Debug.Assert True Regards, Prafull Jadhav 9920553518 On 22 November 2014 at 09:55, Mandeep Baluja rockerna...@gmail.com wrote: Hello Paul, First I would like to thank you from bottom of my *heart* for making such an *efficient code* to handle

Re: $$Excel-Macros$$ Amazing Excel formulas...

Dear Vaibhav Sir, Thanks for the shared us a very useful file. Regards, Prafull Jadhav 9920553518 On 18 September 2014 17:32, Ganesh N ganeshg...@gmail.com wrote: Got it sir!! Thanks One more help sir. Like formulas do you have sample files for macros ? just to learn. im a beginner

Re: $$Excel-Macros$$ Macros get deleted

Dear Rupesh, Have u open it with Enable Macro? and also save it as it Macro Enable file... Regards, Prafull Jadhav 9920553518 On 8 September 2014 12:40, Rupesh Patil patil.rupesh1...@gmail.com wrote: ​Hello Experts I am using office 2013, when download any macro included workbook from

Re: $$Excel-Macros$$ Number to Text Indiann rupee format using formula no add ins UDF

Dear Vaibhavji, Great! Regards, Prafull Jadhav 9920553518 On 8 September 2014 12:55, Vaibhav Joshi v...@vabs.in wrote: FA, It works upto 99 crore, you can modify to extend further. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 8, 2014

Re: $$Excel-Macros$$ Happy Independence Day!

Dear All, Wish you very very happy Independence day. Regards, Prafull Jadhav 9920553518 On 14 August 2014 13:24, Vaibhav Joshi v...@vabs.in wrote: Happy Independence Day! -- 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

Re: $$Excel-Macros$$ need help!!!

find the same Regards, Prafull Jadhav 9920553518 On 8 August 2014 16:19, Mihai Ghilea mihai.ghi...@metabras.ro wrote: Try this... Mihai Ghilea Network administrator [image: Sigla_METABRAS_STEEL_PEOPLEmica] ROMANIA SC METABRAS SRL Brasov Str. Grivitei A44, RO 500182 CUI

Re: $$Excel-Macros$$ need help!!!

find the same... Regards, Prafull Jadhav 9920553518 On 8 August 2014 16:39, Prafull Jadhav prafulltjad...@gmail.com wrote: find the same Regards, Prafull Jadhav 9920553518 On 8 August 2014 16:19, Mihai Ghilea mihai.ghi...@metabras.ro wrote: Try this... Mihai Ghilea Network

$$Excel-Macros$$ Hyperlink

! Regards, Prafull Jadhav ​​ 9920553518 -- 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$$ Hyperlink

Dear Ashish, Thanks for Reply! Actually I am not looking for the same. I want to hyper link with only with one sheet . Regards, Prafull Jadhav 9920553518 On 5 August 2014 14:40, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Prafull, PFA.!!! Regards Ashish On 5 August 2014 11

Re: $$Excel-Macros$$ Hyperlink

it but it is not blinking. Please check my excel file. Regards, Prafull Jadhav 9920553518 On 5 August 2014 15:11, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Prafull, PFA...!!! Regards Ashish On 5 August 2014 14:53, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Ashish, Thanks for Reply

Re: $$Excel-Macros$$ Combining six IF formula into one formula

Awesome!.Vaibhav Sir. Thanks a Lot! Regards, Prafull Jadhav 9920553518 On 28 July 2014 12:28, Vaibhav Joshi v...@vabs.in wrote: hi you cont need such formula.. use this formula =A1-MOD(A1,10)-A1-MOD(A1,10)+10 It is modeless whatever be the range yo have your answer!! Cheers

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

Abhishek Sir, Again you proved that you are Master..! Regards, Prafull Jadhav 9920553518 On 27 May 2014 16:21, Abhishek Jain abhishek@gmail.com wrote: Happy to help :) On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Abhishek Jee, It is really a very

Re: $$Excel-Macros$$ Login password in excel

Dear Abhishek Sir, Great. Regards, Prafull Jadhav 9920553518 On 17 April 2014 12:09, Abhishek Jain abhishek@gmail.com wrote: Dear Amar, Please see the attached file. I hope this works for you. You may login by using any of the following credentials (both username and password

$$Excel-Macros$$ VBA-For Next

Dear All, Good Afternoon! I have a big data which is horizontal .. I have to put it vertically. I am sending sample data ..Please help me for the same. . Regards, Prafull Jadhav 9920553518 -- 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

Re: $$Excel-Macros$$ RE: [XL-VBA Clinic] VBA-For Next

Dear Sir, perfect !... thanks a lot . Regards, Prafull Jadhav 9920553518 On 9 April 2014 16:11, Ravinder ravindervbacli...@gmail.com wrote: PFA...first select range of heading as I have already selected in file. *From:* excelvbacli...@googlegroups.com [mailto: excelvbacli

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Error status No Error ? C ? NC ? Error --How to find out Quality- how to find out Regards, Prafull Jadhav 9920553518 On 17 March 2014 16:58, Prabhu Pinky prabhupin...@gmail.com wrote: can you workout and send me..i did tried.. but am not getting result. if you provide VBA code

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Please check and ..let me know. Regards, Prafull Jadhav 9920553518 On 17 March 2014 21:12, Prafull Jadhav prafulltjad...@gmail.com wrote: Error status No Error ? C ? NC ? Error --How to find out Quality- how to find out Regards, Prafull Jadhav 9920553518 On 17 March 2014 16:58

Re: $$Excel-Macros$$ Average Graph

... It gives wrong Nos to Management. Regards, Prafull Jadhav 9920553518 On 15 March 2014 20:44, ravinder negi ravi_colw...@yahoo.com wrote: pls provide some example in excel with chart On Saturday, March 15, 2014 8:12 AM, Abhishek Jain abhishek@gmail.com wrote: Does this make any

Re: $$Excel-Macros$$ Average Graph

Dear Abhishek Sir, Very good morning. If I now that ddaily frequency of cabs are between 50 to 80. Because of suddenly increased in cabs for few days this affects the overall average. I just want to show normal average.. Which excluding few days highest cabs. Regard, Prafull Jadhav. 9920553518

Re: FW: $$Excel-Macros$$ Conditional Formating

Dear Sir, It is not working.. Please let me know how I can select the all cell in sheet where cell format is % Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:12, Ravinder ravindervbacli...@gmail.com wrote: Pfa. if not receive... *From:* excel-macros@googlegroups.com [mailto

Re: FW: $$Excel-Macros$$ Conditional Formating

also there in sheet that's why I am not able to apply the condition formatting. Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:47, Ravinder ravinderexcelgr...@gmail.com wrote: What you want to do with that selection.color them or else Below is code to color % format cell

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] Averege by Using by Sumproduct.

Dear All, Waiting for the same. Dear All, Thanks for reply.. MY question is when I use the Dynamic Range then output of Avg Response time is coming but it is not applicable to Resolution. Why this happen ..? Please explain Regards, Prafull Jadhav 9920553518 On 12 March 2014 20:10

$$Excel-Macros$$ Re: [XL-VBA Clinic] Averege by Using by Sumproduct.

Dear All, Thanks for reply.. MY question is when I use the Dynamic Range then output of Avg Response time is coming but it is not applicable to Resolution. Why this happen ..? Please explain Regards, Prafull Jadhav 9920553518 On 12 March 2014 17:58, Arvind mishra arvind44mis

$$Excel-Macros$$ Dynamic Range for Pivot

Dear All, Good Afternoon, I want a examples of Dynamic Range of Pivot. for example if i added new data in master file then new rows or data should be added in pivot or suppose i delete the data thane range should be adjust accordingly Thanks in Advance. Regards, Prafull Jadhav 9920553518

$$Excel-Macros$$ Name Range Change through VBA

, Prafull Jadhav 9920553518 -- 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 Please Help

$$Excel-Macros$$ Macro Single code require for if condtion

Then* *Selection.Offset(0, 12).Value = Hisar* *ElseIf Selection.Offset(0, 2).Value = HSR-JMS(HR) Then* *Selection.Offset(0, 12).Value = Hisar* End If Selection.Offset(1, 0).Select Loop Please help me in this regards. Regards, Prafull Jadhav 9920553518 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

Re: $$Excel-Macros$$ Macro Single code require for if condtion

Thanks a lot Sir.. Perfect! Regards, Prafull Jadhav 9920553518 On 4 March 2014 17:21, Paul Schreiner schreiner_p...@att.net wrote: You could replace your If/ElseIf/Endif statement with a Select Case Statement: Select Case Selection.Offset(0, 2).Value Case GURGAON(DELHI-NCR

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

Dear Madam, Very Good Morning Thanks a lot for important and essential information about the hyperlink for dynamic formula. I have done it finally ...and it is working fine. Thanks once again for explaining the whole topic step by step. Regards, Prafull Jadhav 9920553518 On 1 March 2014

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

Great Ravinder Sir.. Regards, Prafull Jadhav 9920553518 On 28 February 2014 15:33, Ravinder ravinderexcelgr...@gmail.com wrote: PFA. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *amar takale *Sent:* Friday, February 28, 2014 3:18 PM

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

Dear Madam, I also trying the same but not able to understand the same. It will be better if you explain the same... Thanks in Advance ...Madam Regards, Prafull Jadhav 9920553518 On 28 February 2014 17:09, amar takale amartak...@gmail.com wrote: Dear Raviderji Priti Thank very much

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

validation. I have created another file but i am unable to create the hyperlink for the same sheet. Thanks in Advance Regards, Prafull Jadhav 9920553518 On 28 February 2014 17:38, priti verma pritiverma1...@gmail.com wrote: Hi Amar, it is simple index match formula and 1 indicates row

$$Excel-Macros$$ Macro Required

Dear All, Good After Noon, I require one macro for attached excel sheet. Appreciate cooperation expected from you. Regards, Prafull Jadhav 9920553518 -- 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: [XL-VBA Clinic] RE: $$Excel-Macros$$ Macro Required

Dear Ravinder Sir, Thanks for Reply..it is working fine. Can we make the same without selecting Range and paste range(Without message box)? Means we need not require fill the Range. Regards, Prafull Jadhav 9920553518 On 26 February 2014 16:59, Ravinder ravindervbacli...@gmail.com wrote

$$Excel-Macros$$ Query for Macro

,Correct then next column(B1) should be contain OK Regards, Prafull Jadhav 9920553518 -- 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

Re: $$Excel-Macros$$ Top Ten Requestors by Macro or formula.

automatically with each company and chart will update accordingly . Regards, Prafull Jadhav 9920553518 On Wed, Dec 18, 2013 at 3:40 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: In Macro use conditional Formatting..use Top 10 option.. Regards, *Amit Desai *– MIS Manager M: +91

RE: $$Excel-Macros$$ Top Ten Requestors by Macro or formula.

Dear All, Very good morning and have great day. Wating for output. Regard, Prafull Jadhav. 9920553518 Dear Prafull, Let your Macro use the master file, get Top 10 list from Master from that list you can just re-fresh the chart. *From:* excel-macros@googlegroups.com [mailto:excel-macros

Re: $$Excel-Macros$$ Value formula is not working

Dear Sir, It is also not working ... Value error is there . Regards, Prafull Jadhav 9920553518 On Mon, Nov 25, 2013 at 1:43 PM, xlstime xlst...@gmail.com wrote: you can try with -- formula like =--A3 . Enjoy Team XLS On Mon, Nov 25, 2013 at 1:19 PM

Re: $$Excel-Macros$$ Value formula is not working

Dear Sir, Same is working on other PC Regards, Prafull Jadhav 9920553518 On Mon, Nov 25, 2013 at 1:49 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Sir, It is also not working ... Value error is there . Regards, Prafull Jadhav 9920553518 On Mon, Nov 25, 2013 at 1:43 PM

Re: $$Excel-Macros$$ Value formula is not working

Same error which is in my first attachmentsir Regard, Prafull Jadhav. 9920553518 On 25-Nov-2013 1:53 PM, xlstime xlst...@gmail.com wrote: please share the snap shot . Enjoy Team XLS On Mon, Nov 25, 2013 at 1:50 PM, Prafull Jadhav prafulltjad

Re: $$Excel-Macros$$ Value formula is not working

Sir...same formula is working in other all friends pc...Only I m facing same problem Regard, Prafull Jadhav. 9920553518 On 25-Nov-2013 2:18 PM, xlstime xlst...@gmail.com wrote: yeah, but can u share the snap shot.. coz ur example sheet formula is working fine on my system

$$Excel-Macros$$ RE: [XL-VBA Clinic] Value formula is not working

Sir, Can you tell me how to check and how modified Regard, Prafull Jadhav. 9920553518 On 25-Nov-2013 7:02 PM, Papnay, Ashish apap...@metlife.com wrote: Hi Prafull, What is the format of date in your system. Like in my system the date formate is MM/DD/YY. *Regards* *Ashish

$$Excel-Macros$$ Value formula is not working

..Please let me know Regards, Prafull Jadhav 9920553518 -- 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

$$Excel-Macros$$ Re: [XL-VBA Clinic] Date format_Not in Proper

Dear Sir, It is not working . Regards, Prafull Jadhav 9920553518 On Mon, Nov 18, 2013 at 3:40 PM, saurabh kumar saurabhkumar8...@gmail.comwrote: Hi Prafull, Please find attached Check Regards Saurabh On Mon, Nov 18, 2013 at 1:11 PM, Prafull Jadhav prafulltjad...@gmail.comwrote

Re: $$Excel-Macros$$ Date format_Not in Proper

Sir thanks for reply. But sir... For Only few rows not get corrected.. Rest things are perfects...why this so. Regard, Prafull Jadhav. 9920553518 On 19-Nov-2013 12:03 AM, ashish koul koul.ash...@gmail.com wrote: is it 1 apr 2013 try to change the setting of ur computer control panel

$$Excel-Macros$$ Re: [XL-VBA Clinic] Date format_Not in Proper

Hi Sir, Thanks for Reply.. I have try this but result is coming wrong ...as out put showing jan and Feb month also .. data is contain from April to Nov .. Regards, Prafull Jadhav 9920553518 On Mon, Nov 18, 2013 at 1:02 PM, saurabh kumar saurabhkumar8...@gmail.comwrote: Hi Prafull

Re: $$Excel-Macros$$ Date format_Not in Proper

DEAR RAJAN SIR, thanks for reply... but output showing jan and feb month also after running macro . Regards, Prafull Jadhav 9920553518 On Mon, Nov 18, 2013 at 12:32 PM, Rajan sharma rajansharma9...@gmail.comwrote: Hi, Try using below: Sub prafu() For Each x In Range(A1:A9000

$$Excel-Macros$$ UDF convert to Macro

Dear All, Very Good Morning ..and Have a Great Day Ahead! I got below Function from our group . I have modified it . We can put Space between word for example PrafullJadhav then output is Prafull Jadhav AjayNareshRane then output will be Ajay Naresh Rane MY question is Can we create Macro

$$Excel-Macros$$ Re: UDF convert to Macro

Dear All, Thanks to Everybody...It is really working fine... Regards, Prafull Jadhav 9920553518 On Tue, Oct 29, 2013 at 10:11 AM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Very Good Morning ..and Have a Great Day Ahead! I got below Function from our group . I have modified

Re: $$Excel-Macros$$ Meaning of Value 2

Thanks a lot Sir, Sir ..can you share one example for the same if possible. *Regards, Prafull Jadhav 9920553518* On Thu, Oct 24, 2013 at 1:00 PM, xlstime xlst...@gmail.com wrote: Value2 always uses the same value that Excel uses. It does not truncate decimal places ,Value2 gives you

Re: $$Excel-Macros$$ Meaning of Value 2

Got it ! Thanks a lot Regard, Prafull Jadhav. 9920553518 On 24-Oct-2013 1:37 PM, xlstime xlst...@gmail.com wrote: sub rr() range(a1).value =date range(a2).value2=date end sub . Enjoy Team XLS On Thu, Oct 24, 2013 at 1:31 PM, Prafull Jadhav prafulltjad

$$Excel-Macros$$ Meaning of Value 2

Dear All , Very GooD Morning and Have a Great Day! I have one query in VBA what is Value 2 . i know Value When and Why Value 2 is use in VBA Code. Appreciate cooperation expected from you *Regards, Prafull Jadhav 9920553518* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Function for coloring particular text

Dear Ravinder Sir, I want to know can we create function for the same. *Regards, Prafull Jadhav 9920553518* On Mon, Sep 30, 2013 at 12:53 PM, Ravinder ravinderexcelgr...@gmail.comwrote: For Each cell In Selection With cell.Characters(Start:=3, Length:=1).Font .Color

$$Excel-Macros$$ Difference Between Function (UDF) and Macro

i have seen one function and i want to create the macro for the same and i am not able to do this. Function number(Text As String) For i = 1 To Len(Text) If IsNumeric(Mid(Text, i, 1)) = True Then jo = jo Mid(Text, i, 1) End If Next i number = jo End Function *Regards, Prafull Jadhav

Re: $$Excel-Macros$$ Total Count of Unique ID's

Dear Ashish, find the same with formula. *Regards, Prafull Jadhav 9920553518* On Mon, Sep 23, 2013 at 1:39 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Anil, Can you please help me to reslove this query through Excel formula. Thanks, Ashish On Monday, September 23, 2013 12

$$Excel-Macros$$ Formatting the Table (Pivot Table data)

Table Border Line to each table First column alignment -left *Regards, Prafull Jadhav 9920553518* * * -- 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

Re: $$Excel-Macros$$ Concatenate.

Dear Ashish Sir, Thanks a lot. Regards, Prafull. On Sat, Sep 14, 2013 at 8:59 AM, ashish koul koul.ash...@gmail.com wrote: you can write udf to concatenate the range On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Can we concatenate

$$Excel-Macros$$ Concatenate.

Dear All, Can we concatenate by using range with Arrey formula.? for example From Range(A2:K2) ..i have to concatenate.. but for this i have to put formula like concatenate(A2,B2,C2,D2...) Can we do this by using Range. concatenate(Range(A2:K2) Regards, Prafull Jadhav. -- Are you

Re: $$Excel-Macros$$ Filter Data of Bold letter

Dear Anil and Xlstime Sir, can we use below method? Sub prafull() For Each x In Range(G2:G139) If x.Font.Bold = True Then x.Offset(0, 1).Value = 1 End If Next x End Sub On Wed, Sep 11, 2013 at 2:23 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Ashish, Pl see the attached

$$Excel-Macros$$ Macro for Hide Column

Dear All, Very Good Morning I have one Query . i am looking in Range (A2:E2) . If cell contain yes word then don't hide otherwise hide the column . for example if in A2 Cell word is Yes , i am Fine then A column must be hide if D2 cell contain Prafull ,Yes is is fine then D column must be hide

Re: $$Excel-Macros$$ Macro for Hide Column

, Prafull Jadhav wrote: Dear All, Very Good Morning I have one Query . i am looking in Range (A2:E2) . If cell contain yes word then don't hide otherwise hide the column . for example if in A2 Cell word is Yes , i am Fine then A column must be hide if D2 cell contain Prafull ,Yes

Re: $$Excel-Macros$$ Need help on silly problem quickly

Remove* * from formula ...for number value On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi Team, Request you to kindly provide me solution to below silly problem I am facing in excel. I am trying to get sum of data range B2 to B6 in cell B8. Answer which I

Re: $$Excel-Macros$$ Output Requier in Vertical

Dear Sir, Plesae explain the for my information. Range(a2:a15).Cells(K, 1) out would be like ABDE.continue but how it come AABCCDDDEEFHHHIIJKLLMN Please explain. It working very fine as per my desire output On Wed, Aug 28, 2013 at 10:53 AM, Prafull Jadhav

Re: $$Excel-Macros$$ Output Requier in Vertical

in row and its hold range(a2:a15)'s value . Enjoy Team XLS On Thu, Aug 29, 2013 at 9:18 AM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Sir, Plesae explain the for my information. Range(a2:a15).Cells(K, 1) out would be like ABDE.continue

$$Excel-Macros$$ Output Requier in Vertical

Dear All, Very Good Morning , I have made macro but i am able to extract output in only one column but i want it in 2 column . Please help me in this regards, Thanks in Advance. Regards, Prafull -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Output Requier in Vertical

On Wed, Aug 28, 2013 at 9:41 AM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All, Very Good Morning , I have made macro but i am able to extract output in only one column but i want it in 2 column . Please help me in this regards, Thanks in Advance. Regards, Prafull

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

.TextRange.Font.Name = Arial Selection.Format.TextFrame2.TextRange.Font.Size = 14 Next End Sub . Enjoy Team XLS On Wed, Aug 21, 2013 at 10:34 AM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All, Very Good Morning, I have made 10 charts and now

Re: $$Excel-Macros$$ Charts Title Font Size Change via VBA

, Aug 21, 2013 at 2:25 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Thanks a lot Sir...It working Fine On Wed, Aug 21, 2013 at 1:12 PM, xlstime xlst...@gmail.com wrote: Try This Sub Chart_Titles() Dim ch As ChartObject For Each ch In ActiveSheet.ChartObjects ch.Activate

$$Excel-Macros$$ Charts Title Font Size Change via VBA

Dear All, Very Good Morning, I have made 10 charts and now I want to change the Size of Font 14 to 9 for Chart Title. is it possible to change it through the VBA for example For each For Next Do until if yes , Please provide the same Thanks in Advance Regards, Prafull Jadhav

Re: $$Excel-Macros$$ Auto Sum DETAIL ...- HELP PLZ

Dear Sajid, if sum (D2 to 1000) is = B9 then what should be result. in F column , in which cell you must have result. Please see the attachment . On Mon, Aug 12, 2013 at 11:28 AM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear Prafull Jadhav Ji, My concept is different, I have list of amount

Re: $$Excel-Macros$$ Auto Sum - HELP PLZ

please let me know that if sum (D2:D1000) is =B9 then output will display in F column only one time or D2 to D3 is less then B9 then out put will come at F3 D2 to D4 is less then B9 then out put will come at F4 Regards, Prafull Jadhav. On Sun, Aug 11, 2013 at 5:49 PM, SAJID MEMON sajidwi

Re: $$Excel-Macros$$ Auto Sum by List- HELP PLZ

SAME TO YOU...Happy EID. Please let me know ..Whole Range sum of D column is less then Cells B9 then output will in F Column,. Please check excel sheet . Please let me know if any further changes . Regards, Prafull Jadhav. On Sat, Aug 10, 2013 at 7:02 PM, SAJID MEMON sajidwi...@hotmail.com

Re: $$Excel-Macros$$ Text to Column Vai VBA code

Sub Pada 09/08/2013 18:33, Prafull Jadhav menulis: Dear Experts, Can we have VBA code for the attached excel sheet. Reg, Prafull -- 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

Re: $$Excel-Macros$$ Text to Column Vai VBA code

x In Range(A2:A10) Range(B x.Row :D x.Row) = Split(Replace(Replace(Replace(x.Text, Days , ), Hrs , ), Mins, ), ) Next End Sub Once again Thanks . Regards, Prafull Jadhav. On Sat, Aug 10, 2013 at 6:29 AM, De Premor d...@premor.net wrote: firstly, Str() as variant is an array that we need

Re: $$Excel-Macros$$ Text to Column Vai VBA code

Dear Sir, Yes.You are Right ,Sir.. for preventing error you have added the minor code. I got it. Finally i got my output ...Thanks a lot... Have a Great Day .. Regards, Prafull Jadhav. On Sat, Aug 10, 2013 at 7:35 AM, De Premor d...@premor.net wrote: That is, you've almost done

Re: $$Excel-Macros$$ VBA code require

Thanks a Sir lot. Actually, i am learning the same . I was able to write the code for single column but i didnot understand how to write for second column Regards, Prafull Jadhav. 9920553518 On Wed, Aug 7, 2013 at 9:05 PM, ashish koul koul.ash...@gmail.com wrote: Sub test() For j = 1

Re: $$Excel-Macros$$ Tricky tricks - 1

Sir , Can we do this by using Macro Sub prafull() For Each x In Range(B2:B10) x.Value = = x.Value Next End Sub Regards, Prafull On Tue, Jul 30, 2013 at 12:31 PM, xlstime xlst...@gmail.com wrote: if we have more then thousands of records than? . Enjoy Team XLS

$$Excel-Macros$$ Chart Query

Dear Expert , I have made pivot ..I want to make it one Graph. I am not able to make it in one Graph... Can anyone can provide the same with attractive Graph. Thanks in Advance. Regards, Prafull jadhav. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

Re: $$Excel-Macros$$ Chart Query

Dear Anil, thanks for the same. Actually I require one chart which contain all information . Regards Prafull Jadhav On Fri, Jul 26, 2013 at 3:52 PM, Anil B ank.bira...@gmail.com wrote: Hi Prafull, Find attached the attractive chart as you requested. Thanks, Anil On Fri, Jul 26, 2013

Re: $$Excel-Macros$$ Chart Query

Dear Anil, I have to preset the same in presentation... I think i have to prepare the same with Different chart. Thanks for the same. Red, Prafull Jadhav. On Fri, Jul 26, 2013 at 4:26 PM, Anil B ank.bira...@gmail.com wrote: Check it and let me know is it ok. On Fri, Jul 26, 2013 at 4

Re: $$Excel-Macros$$ Chart Query

at 4:47 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Anil, I have to preset the same in presentation... I think i have to prepare the same with Different chart. Thanks for the same. Red, Prafull Jadhav. On Fri, Jul 26, 2013 at 4:26 PM, Anil B ank.bira...@gmail.com wrote

$$Excel-Macros$$ Un protect the excel file

Dear Experts, I have given password excel file but I have forget the password ..Is there any way to recovery password. Thanks in advance. Regards, Prafull Jadhav. -- 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

Re: $$Excel-Macros$$ Un protect the excel file

Dear Sir, There is no any software for the same . I cant send the file as it contain important information. Regards, Prafull On Tue, Jul 23, 2013 at 2:37 PM, Ankit Mehra ankitmehr...@gmail.com wrote: Hi Prafull, Please send the file. On Tue, Jul 23, 2013 at 11:30 AM, Prafull Jadhav

Re: $$Excel-Macros$$ Un protect the excel file

://www.excelpasswordrecovery.net/ http://www.elcomsoft.com/aopb.html http://www.intelore.com/excel-password-recovery.php There are also other software you can download from the internet. Regards, Vijaykumar On Tue, Jul 23, 2013 at 3:28 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Sir

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Expert , Can you expline the bold line as i want to know deeply. Function Reverse(Text As String) As String Dim i As Integer Dim StrNew As String Dim strOld As String strOld = Trim(Text) For i = 1 To Len(strOld) * StrNew = Mid(strOld, i, 1) StrNew* Next i

Re: $$Excel-Macros$$ Deleting Blank Rows

Dear Amit Sir, you can do it by filter data. 1 go at end of row where data is end then last row and select all till top (down to up) 2 filter on it then you will get blank data ...you can remove it easy. Regards, prafull 9920553518 On Sat, Jul 20, 2013 at 6:02 PM, Amit Desai (MERU)

Re: $$Excel-Macros$$ Difference Between Iferror Iserror

both are same. in 2003 there was iferror and in 2007 it replaced by iserror. On Thu, Jul 11, 2013 at 4:09 PM, Raj Kumar rajlu...@gmail.com wrote: Hi Group, Kindly let us know the difference between Iserror iferror in excel Regards Raj Bharti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Simple formula required

Dear Amar, find the same with easy...by using mid function. Regards Prafull On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar kumarmaury...@yahoo.com wrote: -- *From:* amar takale amartak...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, 4 September

Re: $$Excel-Macros$$ Vlookup function using with match columns

Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E emuralidha...@gmail.comwrote: Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share

Re: $$Excel-Macros$$ Vlookup function using with match columns

result by using vlookup function? Thanks in advance. On 10 July 2013 16:34, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E emuralidha...@gmail.comwrote: Dear friends, Good afternoon, I

Re: $$Excel-Macros$$ Need Formula

Dear Prabhakar, find the same ...It is alternate use... Our expert can give you better solution on it. Regards, Prafull Jadhav. MIS-executive. On Fri, Jul 5, 2013 at 11:27 AM, Prabhakar S H prabakar.k...@gmail.comwrote: Hi Team, I need your help to get details with formula in attached

Re: $$Excel-Macros$$ Query in For Each Next

Thanks Sir. On Wed, Jul 3, 2013 at 10:52 AM, Vabs VBA v...@vabs.in wrote: Hi X refer to each cell in range A1 to D5. Thanks On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All, Good Morning.. I got below macro from net ..Can you explain me what x stand

$$Excel-Macros$$ Query in For Each Next

Dear All, Good Morning.. I got below macro from net ..Can you explain me what x stand here... *Sub Upper_()* *For Each x In Range(A1:D5)* *'For Each x In Range(A1:D5)* * * *x.Value = UCase(x.Value)* *'x.Value = UCase(x.Value)* * * *Next* * * *Thanks in Advance.* *Regards,* *Prafull Jadhav

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Thanks once again.Madam On Fri, Jun 21, 2013 at 11:48 AM, priti verma pritiverma1...@gmail.comwrote: Yes you can do it with macro, See pfa On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Madam, Thanks a lot ... Can we make it from macro

$$Excel-Macros$$ Horizontal to Vertical in One colume

Dear Expert, Dear All, My date is horizontal ..i want to pull it in one column . thanks in advance Regards, Prafull Jadhav. -- 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

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Dear Madam, Thanks a lot ... Can we make it from macro ... Regards, Prafull Jadhav. On Fri, Jun 21, 2013 at 11:24 AM, priti verma pritiverma1...@gmail.comwrote: Hi prafull, PFA On Fri, Jun 21, 2013 at 11:16 AM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Expert, Dear All

$$Excel-Macros$$ Macro Require.

Dear All, find the excel sheeti need macro for the same Regards, Prafull -- 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,

Re: $$Excel-Macros$$ Conditional Search Replace

Dear XLS, if we not declarer variable , will code run properly .? suppose ...we write code as per below. Sub conditionalreplace() For Each Range In Range(D1:D10) If Range.Value 0.8 Then Range = .80 End If Next End Sub if not ...Please

  1   2   >