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

2015-09-08 Thread Prafull Jadhav
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 < &g

Re: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING

2015-08-27 Thread Prafull Jadhav
​select that column -Text to Column ( in Data Tab) -Click Finish ​ Regards, Prafull Jadhav 9920553518 On 27 August 2015 at 18:49, SUDHIR VERMA wrote: > Dear Friends, > Please help me as per attached sheet. I have data of 25k row. there are > some code formatting as text. So you ar

Re: $$Excel-Macros$$ need Excel formula

2015-08-27 Thread Prafull Jadhav
Dear Shrinivas, You will get this after selecting formula and Press F9 For example select 1/(A2:A18=F3) and then Press F9 Regards, Prafull Jadhav 9920553518 On 27 August 2015 at 18:05, Pankaj Sharma wrote: > Hi Shrinivas, > > > "($A$2:$A$17=F2)" Here, A2:A17 array chec

Re: $$Excel-Macros$$ need Excel formula

2015-08-27 Thread Prafull Jadhav
Great ... Abhishekji Regards, Prafull Jadhav 9920553518 On 27 August 2015 at 15:51, Pankaj Sharma wrote: > Thank you Abhishek Jain > > On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain > wrote: > >> HTH >> >> On Thu, Aug 27, 2015 at 3:18 PM, Pankaj S

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

2014-12-06 Thread Prafull Jadhav
Dear Ashish, Great! You have given explanation Step by Step. Regards, Prafull Jadhav 9920553518 On 5 December 2014 at 17:13, Ashish Kumar 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

2014-12-03 Thread Prafull Jadhav
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

2014-11-22 Thread Prafull Jadhav
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 wrote: > Hello Paul, > > First I would like to thank you from bottom of my *heart* for making such > an *efficient code

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

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

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

2014-09-08 Thread Prafull Jadhav
Dear Vaibhavji, Great! Regards, Prafull Jadhav 9920553518 On 8 September 2014 12:55, Vaibhav Joshi 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.* > > O

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

2014-09-08 Thread Prafull Jadhav
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 wrote: > > ​Hello Experts > I am using office 2013, when download any macro included workbook from > this gro

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

2014-08-14 Thread Prafull Jadhav
Dear All, Wish you very very happy Independence day. Regards, Prafull Jadhav 9920553518 On 14 August 2014 13:24, Vaibhav Joshi 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 of

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

2014-08-08 Thread Prafull Jadhav
find the same... Regards, Prafull Jadhav 9920553518 On 8 August 2014 16:39, Prafull Jadhav wrote: > find the same > > Regards, > Prafull Jadhav > 9920553518 > > > On 8 August 2014 16:19, Mihai Ghilea wrote: > >> Try this... >> >> >> >&g

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

2014-08-08 Thread Prafull Jadhav
find the same Regards, Prafull Jadhav 9920553518 On 8 August 2014 16:19, Mihai Ghilea wrote: > Try this... > > > > Mihai Ghilea > > Network administrator > > [image: Sigla_METABRAS_STEEL_PEOPLEmica] > > ROMANIA > > SC METABRAS SRL Brasov > > St

Re: $$Excel-Macros$$ Hyperlink

2014-08-05 Thread Prafull Jadhav
Dear Ashish, Only one changes , Blink on the ( in Details sheets)...which cell is selected or highlighted Not on the index sheet. for example : once i click on hyperlink cell(in index) then the cell should be blink of Details sheets which is selected. Regards, Prafull Jadhav 9920553518 On 5

Re: $$Excel-Macros$$ Hyperlink

2014-08-05 Thread Prafull Jadhav
ade it but it is not blinking. Please check my excel file. Regards, Prafull Jadhav 9920553518 On 5 August 2014 15:11, Ashish Kumar wrote: > Hi Prafull, > > PFA...!!! > > > Regards > Ashish > > On 5 August 2014 14:53, Prafull Jadhav wrote: > >> Dear Ashis

Re: $$Excel-Macros$$ Hyperlink

2014-08-05 Thread Prafull Jadhav
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 wrote: > Hi Prafull, > > > PFA.!!! > > > Regards > Ashish > > >

$$Excel-Macros$$ Hyperlink

2014-08-04 Thread Prafull Jadhav
! 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$$ Combining six IF formula into one formula

2014-07-28 Thread Prafull Jadhav
Awesome!.Vaibhav Sir. Thanks a Lot! Regards, Prafull Jadhav 9920553518 On 28 July 2014 12:28, Vaibhav Joshi 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 ra

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

2014-07-27 Thread Prafull Jadhav
Dear Vaibhav Sir, Your formula is very good,Appreciate! Can we do the same for bucket by using same technique. for example 0-10,11-20,21-30 if cell is contain 7 then it should be come under 0-10 bucket if cell is contain 22 then it should be come under 21-30 bucket. Regards, Prafull Jadhav

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

2014-05-27 Thread Prafull Jadhav
Abhishek Sir, Again you proved that you are Master..! Regards, Prafull Jadhav 9920553518 On 27 May 2014 16:21, Abhishek Jain wrote: > Happy to help :) > > > On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal wrote: > >> Dear Abhishek Jee, >> >> It is

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

2014-04-17 Thread Prafull Jadhav
Dear Abhishek Sir, Great. Regards, Prafull Jadhav 9920553518 On 17 April 2014 12:09, Abhishek Jain 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 > passwo

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

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

$$Excel-Macros$$ VBA-For Next

2014-04-09 Thread Prafull Jadhav
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) !

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

2014-03-17 Thread Prafull Jadhav
Please check and ..let me know. Regards, Prafull Jadhav 9920553518 On 17 March 2014 21:12, Prafull Jadhav wrote: > Error status No Error ? C ? NC ? > > Error --How to find out Quality- how to find out > > Regards, > Prafull Jadhav > 9920553518 > > > On 17

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

2014-03-17 Thread Prafull Jadhav
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 wrote: > can you workout and send me..i did tried.. but am not getting result. > > if you provide VBA code.. it would be

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread Prafull Jadhav
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: $$Excel-Macros$$ Average Graph

2014-03-15 Thread Prafull Jadhav
gives wrong Nos to Management. Regards, Prafull Jadhav 9920553518 On 15 March 2014 20:44, ravinder negi 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

$$Excel-Macros$$ Average Graph

2014-03-15 Thread Prafull Jadhav
stable average count. if i include the Highest numbers in series then Average suddenly goes up..and charts look like jumping at highest point. for avoid this ..which type of formula i have to apply here which show stable Average or Graphs. Regards, Prafull Jadhav 9920553518 -- Are you =EXP(E:RT) or

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

2014-03-14 Thread Prafull Jadhav
mulas 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 wrote: > What you want to do with that selection.color them or else > > > > Below is code to color % format cell

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

2014-03-14 Thread Prafull Jadhav
Dear Sir, I want a VBA code ;which will select the all cell in sheet where cell format is "0.00%" Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:31, Ravinder wrote: > You just select the whole range of tables and put condition formatting as > already applied on $A$

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

2014-03-14 Thread Prafull Jadhav
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 wrote: > Pfa. if not receive... > > > > *From:* excel-macros@googlegroups.co

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

2014-03-13 Thread Prafull Jadhav
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.

2014-03-12 Thread Prafull Jadhav
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 wrote: > D

$$Excel-Macros$$ Dynamic Range for Pivot

2014-03-10 Thread Prafull Jadhav
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

2014-03-06 Thread Prafull Jadhav
ards, 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 Pl

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

2014-03-04 Thread Prafull Jadhav
Thanks a lot Sir.. Perfect! Regards, Prafull Jadhav 9920553518 On 4 March 2014 17:21, Paul Schreiner 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)&quo

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

2014-03-04 Thread Prafull Jadhav
If Selection.Offset(0, 2).Value = "HSR-JINDAL CLUB(HR)" Then* *Selection.Offset(0, 12).Value = "Hisar"* *ElseIf Selection.Offset(0, 2).Value = "HSR-JINDAL HOUSE" Then* *Selection.Offset(0, 12).Value = "Hisar"* *ElseIf Selection.Offset(0, 2).Value = "HSR-

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

2014-03-01 Thread Prafull Jadhav
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

2014-02-28 Thread Prafull Jadhav
s used for data 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 wrote: > Hi Amar, > > it is simple index match formula and 1 indicates r

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

2014-02-28 Thread Prafull Jadhav
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 wrote: > Dear Raviderji & Priti > > Thank very much for

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

2014-02-28 Thread Prafull Jadhav
Great Ravinder Sir.. Regards, Prafull Jadhav 9920553518 On 28 February 2014 15:33, Ravinder 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: [XL-VBA Clinic] RE: $$Excel-Macros$$ Macro Required

2014-02-26 Thread Prafull Jadhav
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 wrote: > Pfa , first select

$$Excel-Macros$$ Macro Required

2014-02-26 Thread Prafull Jadhav
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

$$Excel-Macros$$ Query for Macro

2014-02-19 Thread Prafull Jadhav
for example if A1 contain words like "NO",YES,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 fo

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

2013-12-18 Thread Prafull Jadhav
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-ma

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

2013-12-18 Thread Prafull Jadhav
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) wrote: > In Macro use conditional Formatting..use Top 10 option.. > > > > Regards, > > *Amit Desai *– MIS Manager

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

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

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

2013-11-25 Thread Prafull Jadhav
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" wrote: > yeah, but can u share the snap shot.. > > coz ur example sheet formula is workin

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

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

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

2013-11-25 Thread Prafull Jadhav
Dear Sir, Same is working on other PC Regards, Prafull Jadhav 9920553518 On Mon, Nov 25, 2013 at 1:49 PM, Prafull Jadhav wrote: > Dear Sir, > It is also not working ... > > Value error is there . > > Regards, > Prafull Jadhav > 9920553518 > > > On Mon,

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

2013-11-25 Thread Prafull Jadhav
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 wrote: > you can try with "--" > > formula like =--A3 > > . > > Enjoy > Team XLS >

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

2013-11-24 Thread Prafull Jadhav
..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

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

2013-11-18 Thread Prafull Jadhav
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" 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

2013-11-18 Thread Prafull Jadhav
Dear Sir, It is not working . Regards, Prafull Jadhav 9920553518 On Mon, Nov 18, 2013 at 3:40 PM, saurabh kumar wrote: > Hi Prafull, > > Please find attached & Check > > Regards > Saurabh > > > On Mon, Nov 18, 2013 at 1:11 PM, Prafull Jadhav > wrote: &

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

2013-11-17 Thread Prafull Jadhav
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 wrote: > Hi, Try using below: > > Sub prafu() > For Each x In Range("A1:A9000&quo

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

2013-11-17 Thread Prafull Jadhav
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 wrote: > Hi Prafull, > > Please

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

2013-10-28 Thread Prafull Jadhav
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 wrote: > Dear All, > Very Good Morning ..and Have a Great Day Ahead! > > I got below Function from our group . I have modified it

$$Excel-Macros$$ UDF convert to Macro

2013-10-28 Thread Prafull Jadhav
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 by

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

2013-10-24 Thread Prafull Jadhav
Got it ! Thanks a lot Regard, Prafull Jadhav. 9920553518 On 24-Oct-2013 1:37 PM, "xlstime" wrote: > > sub rr() > range("a1").value =date > range("a2").value2=date > end sub > > > . > > Enjoy > Team XLS &

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

2013-10-24 Thread Prafull Jadhav
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 wrote: > Value2 always uses the same value that Excel uses. It does not truncate > decimal places ,Value2 gives you DateSerial

$$Excel-Macros$$ Meaning of "Value 2"

2013-10-23 Thread Prafull Jadhav
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:

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

2013-09-30 Thread Prafull Jadhav
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 wrote: > For Each cell In Selection > > With cell.Characters(Start:=3, Length:=1).Font > > .Color = vb

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

2013-09-29 Thread Prafull Jadhav
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 Ja

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

2013-09-29 Thread Prafull Jadhav
Dear all, I want function for coloring particular text. For example if cell contian word 'prafull' and I want to red colors to 'l' character in cell. Regard, Prafull Jadhav. 9920553518 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(

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

2013-09-23 Thread Prafull Jadhav
Dear Ashish, find the same with formula. *Regards, Prafull Jadhav 9920553518* On Mon, Sep 23, 2013 at 1:39 PM, Ashish Kumar wrote: > Dear Anil, > > Can you please help me to reslove this query through Excel formula. > > Thanks, > Ashish > > > On Monday, September

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

2013-09-21 Thread Prafull Jadhav
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.

2013-09-14 Thread Prafull Jadhav
Dear Ashish Sir, Thanks a lot. Regards, Prafull. On Sat, Sep 14, 2013 at 8:59 AM, ashish koul wrote: > you can write udf to concatenate the range > > > On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav > wrote: > >> Dear All, >> >> Can we concatenate by

$$Excel-Macros$$ Concatenate.

2013-09-13 Thread Prafull Jadhav
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, P

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

2013-09-11 Thread Prafull Jadhav
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, अनिल नारायण गवली wrote: > Dear Ashish, > > Pl see the attached workbook. > Is it ok?

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

2013-09-06 Thread Prafull Jadhav
t; Next > End Sub > > > On 07-09-2013 10:46, 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 . >

$$Excel-Macros$$ Macro for Hide Column

2013-09-06 Thread Prafull Jadhav
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 mus

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

2013-09-04 Thread Prafull Jadhav
Remove* "" * from formula ...for number value On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote: > 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 > am getting is

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

2013-08-28 Thread Prafull Jadhav
ue remains same till "K" count = count no of active cells in row > and its hold range("a2:a15")'s value > > > . > > Enjoy > Team XLS > > > > On Thu, Aug 29, 2013 at 9:18 AM, Prafull Jadhav > wrote: > >> D

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

2013-08-28 Thread Prafull Jadhav
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, Praf

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

2013-08-27 Thread Prafull Jadhav
;a2:a15").Cells(K, 1) > Next > Next > > End Sub > > > . > > Enjoy > Team XLS > > > > On Wed, Aug 28, 2013 at 9:41 AM, Prafull Jadhav > wrote: > >> Dear All, >> >> Very Good Morning , >> >> I ha

$$Excel-Macros$$ Output Requier in Vertical

2013-08-27 Thread Prafull Jadhav
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 =TIME(2,DO:IT,N:OW)

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

2013-08-21 Thread Prafull Jadhav
ull End Sub On Wed, Aug 21, 2013 at 2:25 PM, Prafull Jadhav wrote: > Thanks a lot Sir...It working Fine > > > On Wed, Aug 21, 2013 at 1:12 PM, xlstime wrote: > >> Try This >> >> Sub Chart_Titles() >> >> Dim ch As ChartObject >

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

2013-08-21 Thread Prafull Jadhav
; Selection.Format.TextFrame2.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, Prafu

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

2013-08-20 Thread Prafull Jadhav
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

2013-08-11 Thread Prafull Jadhav
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 wrote: > Dear Prafull Jadhav Ji, > My concept is different, I have list of amount... if an

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

2013-08-11 Thread Prafull Jadhav
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 wr

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

2013-08-10 Thread Prafull Jadhav
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 wrote: > Dear Expe

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

2013-08-09 Thread Prafull Jadhav
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 wrote: > That is, you've almost done with it, jus

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

2013-08-09 Thread Prafull Jadhav
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, Praf

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

2013-08-09 Thread Prafull Jadhav
ount) > If InStr(1, Rng, "Days") > 0 Then > Range("B" & Rng.Row & ":D" & Rng.Row) = _ > Split(Replace(Replace(Replace(Rng.Text, "Days ", ""), "Hrs ", > ""), "Mins",

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

2013-08-07 Thread Prafull Jadhav
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 wrote: > Sub test() > > For j = 1 To Ran

$$Excel-Macros$$ VBA code require

2013-08-06 Thread Prafull Jadhav
Dear All, Very Good Morning. Please provide me VBA code as i am not able to write it . Thanks in Advance. 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/

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

2013-07-30 Thread Prafull Jadhav
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 wrote: > if we have more then thousands of records than? > > . > > Enjoy > Team XLS > > > >

Re: $$Excel-Macros$$ Chart Query

2013-07-26 Thread Prafull Jadhav
; On Fri, Jul 26, 2013 at 4:47 PM, Prafull Jadhav > wrote: > >> 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, >> >>

Re: $$Excel-Macros$$ Chart Query

2013-07-26 Thread Prafull Jadhav
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 wrote: > Check it and let me know is it ok. > > > > On Fri, Jul 26, 2013 at 4

Re: $$Excel-Macros$$ Chart Query

2013-07-26 Thread Prafull Jadhav
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 wrote: > Hi Prafull, > > Find attached the attractive chart as you requested. > > Thanks, > Anil > > > On F

$$Excel-Macros$$ Chart Query

2013-07-26 Thread Prafull Jadhav
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$$ Macro for Concatenate

2013-07-25 Thread Prafull Jadhav
t;|" & Range("A1") > > Please remember, that i in our code is refer to a Range as defined in > first line => Dim i as Range > And Range has default property => Value > i.value will same as i > Range("A1").value will same as just Range("A1"

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

2013-07-23 Thread Prafull Jadhav
swordrecoverysoftware.org/ > http://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, 201

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

2013-07-23 Thread Prafull Jadhav
Dear Paul Sir, Thanks for the information . I will search it by Google. Henceforth same will not happen again. Regards Prafull Jadhav. On Tue, Jul 23, 2013 at 5:13 PM, Paul Schreiner wrote: > See Forum Rules #3: > "Don't post questions regarding breaking or bypassing any se

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

2013-07-23 Thread Prafull Jadhav
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 wrote: > Hi Prafull, > > Please send the file. > > > On Tue, Jul 23, 2013 at 11:30 AM, Prafull Jadhav

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

2013-07-22 Thread Prafull Jadhav
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$$ Query - How to make reversal string.

2013-07-21 Thread Prafull Jadhav
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 R

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

2013-07-20 Thread Prafull Jadhav
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) wrote: >

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

2013-07-11 Thread Prafull Jadhav
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 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)) in Excel?

  1   2   >