Re: $$Excel-Macros$$ Extract last and first from columns.
Dear All experts, Any update on my query Please. With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 10:33 AM, Rajan sharma rajansharma9...@gmail.comwrote: Thanks Amir sir, I have elaborated my query further in excel file, please find the attachment. With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 10:22 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: can you further brief? On Fri, Sep 27, 2013 at 9:49 AM, Rajan sharma rajansharma9...@gmail.comwrote: Any body please suggest formulas or macros. please if it is possible.. Thanks With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 9:07 AM, Rajan sharma rajansharma9...@gmail.com wrote: Dear experts, I want to extract only first and last values or string from Columns, Please guide. Please find the attachment, i have provide sample. With warm regards, Rajan Sharma -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Aamir Shahzad -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help,
Re: $$Excel-Macros$$ paste special particular formula
So problem was the reference in formulas , if any formula have reference like A1:A5 and when it will get evaluate by VBA (i am using Evaluate here) it will always assume that reference is from activesheet until we provide full reference like Sheet1!A1:A5, but it is complex to write that code , so the simple solution would to be to activate that sheet where the formula is going to be evaluated, try this code , Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet Dim wksLastActive As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 Application.ScreenUpdating = False Set wksLastActive = ThisWorkbook.ActiveSheet For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then wksSheet.Activate For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR wksSheet.UsedRange.Value = VarArr End If Set rngRange = Nothing End If Next wksSheet wksLastActive.Activate Application.ScreenUpdating = True MsgBox strFormula has been replaced in lngCount Cells, vbInformation End Sub On Fri, Sep 27, 2013 at 12:08 AM, Mukesh Kumar mukeshka...@gmail.comwrote: Rajan Ji, Plz see attached file. I have inserted the macro code in it. But it is giving wrong results. Plz check. Regards, Mukesh Kumar On Thu, Sep 26, 2013 at 9:45 PM, rajan verma rajanverma1...@gmail.comwrote: use this one. Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR End If End If wksSheet.UsedRange.Value = VarArr Next wksSheet MsgBox strFormula has been replaced in lngCount Cells, vbInformation End Sub On Thu, Sep 26, 2013 at 10:14 AM, rajan verma rajanverma1...@gmail.comwrote: Try this one Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR End If End If Next wksSheet ActiveSheet.UsedRange.Value = VarArr MsgBox strFormula has been replaced in lngCount Cells, vbInformation End Sub On Thu, Sep 26,
Re: $$Excel-Macros$$ Index match help
Hi Jeremy, Please find attached file.. The range here I declared is something different because I think San Diego ($85,394.40) is having amount greater than 80,000 and less than 90,000 so its percentage should be 5.0% not 4.7% (as said by you). Please let me know the limits so that the formula can be corrected as per requirement. Thanks On Fri, Sep 27, 2013 at 2:56 AM, Jeremy Lawson lawso...@gmail.com wrote: Hi everybody. I am dealing with a rather complex equation, and could use some help. Most of the cells in the attached spreadsheet are blank, because the data are confidential. The relevant columns are highlighted. Basically, I am trying to use index match to find geographic salary differentials. Depending upon what city an employee is based in, and what his salary is nearest to, he will have a different geographic salary differential. Based upon the city and salary data in the first tab, I want to pull in the percentage salary adjustment in the second tab. I want to use straight rounding, so a salary of $34,999.99 will go to $30,000, and a salary of $35,000 will go to $40,000. I have an index match formula, that seems to work, in cell AG1 of Employee data tab. It won't copy down for some reason. Can anybody help me out? I don't know why this would be. Thanks! -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Copy of Compensation Analysis - Forum.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ paste special particular formula
Thanks a lot Rajan Ji for your help. This code is working fine. Regards, Mukesh Kumar On Fri, Sep 27, 2013 at 12:03 PM, rajan verma rajanverma1...@gmail.comwrote: So problem was the reference in formulas , if any formula have reference like A1:A5 and when it will get evaluate by VBA (i am using Evaluate here) it will always assume that reference is from activesheet until we provide full reference like Sheet1!A1:A5, but it is complex to write that code , so the simple solution would to be to activate that sheet where the formula is going to be evaluated, try this code , Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet Dim wksLastActive As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 Application.ScreenUpdating = False Set wksLastActive = ThisWorkbook.ActiveSheet For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then wksSheet.Activate For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR wksSheet.UsedRange.Value = VarArr End If Set rngRange = Nothing End If Next wksSheet wksLastActive.Activate Application.ScreenUpdating = True MsgBox strFormula has been replaced in lngCount Cells, vbInformation End Sub On Fri, Sep 27, 2013 at 12:08 AM, Mukesh Kumar mukeshka...@gmail.comwrote: Rajan Ji, Plz see attached file. I have inserted the macro code in it. But it is giving wrong results. Plz check. Regards, Mukesh Kumar On Thu, Sep 26, 2013 at 9:45 PM, rajan verma rajanverma1...@gmail.comwrote: use this one. Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC Next lngR End If End If wksSheet.UsedRange.Value = VarArr Next wksSheet MsgBox strFormula has been replaced in lngCount Cells, vbInformation End Sub On Thu, Sep 26, 2013 at 10:14 AM, rajan verma rajanverma1...@gmail.comwrote: Try this one Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim lngR As Long Dim lngC As Long Dim lngCount As Long Dim wksSheet As Worksheet strFormula = InputBox(Enter formula name to replace with values) lngCount = 0 For Each wksSheet In ThisWorkbook.Worksheets Set rngRange = wksSheet.UsedRange If Not rngRange Is Nothing Then VarArr = rngRange.Formula If IsArray(VarArr) Then For lngR = LBound(VarArr) To UBound(VarArr) For lngC = LBound(VarArr) To UBound(VarArr, 2) If Not IsEmpty(VarArr(lngR, lngC)) Then If UCase(VarArr(lngR, lngC)) Like * UCase(strFormula) * Then VarArr(lngR, lngC) = Evaluate(VarArr(lngR, lngC)) lngCount = lngCount + 1 End If End If Next lngC
RE: $$Excel-Macros$$ paste special particular formula
But where u want to paste those formula means which range all sheets have the same format.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mukesh Kumar Sent: Thursday, September 26, 2013 3:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ paste special particular formula Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Extract last and first from columns.
Dear De Premor sir, Awesome and miracle solution, i thought of it cannot be done in excel. But you have proven me wrong. thanks you very very much, you have save my time a lot by this solution. Thnks to all With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 1:07 PM, De Premor d...@premor.net wrote: PFA On 27-09-2013 13:18, Rajan sharma wrote: Dear All experts, Any update on my query Please. With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 10:33 AM, Rajan sharma rajansharma9...@gmail.comwrote: Thanks Amir sir, I have elaborated my query further in excel file, please find the attachment. With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 10:22 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: can you further brief? On Fri, Sep 27, 2013 at 9:49 AM, Rajan sharma rajansharma9...@gmail.com wrote: Any body please suggest formulas or macros. please if it is possible.. Thanks With warm regards, Rajan Sharma On Fri, Sep 27, 2013 at 9:07 AM, Rajan sharma rajansharma9...@gmail.com wrote: Dear experts, I want to extract only first and last values or string from Columns, Please guide. Please find the attachment, i have provide sample. With warm regards, Rajan Sharma -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Aamir Shahzad -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at
$$Excel-Macros$$ Autofill while typing in a cell
Hey VBA Buddies, Hope al iz well. Here is my query. In excel , is it possible to add auto fill while typing a particular text. I have some data somewhere in excel and i am trying to add autofill function if i am typing a cell, i just want to see suggestions those words starts with the text i entered. like : If i type Total, i want to get suggestions of words which starts with total. Thanks in ad. -Pavan -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Fwd:Extract last and first from columns.
Premor sir, I am getting error while run the macros. i have attached my error file. please check if i may be wrong while executing this code to other file. With warm regards, Rajan Sharma -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Book8.xlsm Description: Binary data
Re: $$Excel-Macros$$ paste special particular formula
Rajesh Ji, In my workbook, formulas are in range b. This macro code is working on other ranges also. Thanks to you very much. Regards, Mukesh Kumar On Fri, Sep 27, 2013 at 1:17 PM, Ravinder ravinderexcelgr...@gmail.comwrote: But where u want to paste those formula means which range all sheets have the same format.. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Thursday, September 26, 2013 3:10 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ paste special particular formula ** ** Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Autofill while typing in a cell
Awesome Anil.. Genious you are. Thanks much On Fri, Sep 27, 2013 at 3:13 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear Pavan, See the attached sheet. I have take a combobox help Warm Regards, Gawli Anil Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Fri, Sep 27, 2013 at 2:16 PM, Pavan Valluru pavansai.vall...@gmail.com wrote: Hey VBA Buddies, Hope al iz well. Here is my query. In excel , is it possible to add auto fill while typing a particular text. I have some data somewhere in excel and i am trying to add autofill function if i am typing a cell, i just want to see suggestions those words starts with the text i entered. like : If i type Total, i want to get suggestions of words which starts with total. Thanks in ad. -Pavan -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ paste special particular formula
This was the initial request from you need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. i cant see anywhere you need it for column B only :) Regards Rajan. On Fri, Sep 27, 2013 at 3:55 AM, Mukesh Kumar mukeshka...@gmail.com wrote: Rajesh Ji, In my workbook, formulas are in range b. This macro code is working on other ranges also. Thanks to you very much. Regards, Mukesh Kumar On Fri, Sep 27, 2013 at 1:17 PM, Ravinder ravinderexcelgr...@gmail.comwrote: But where u want to paste those formula means which range all sheets have the same format.. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mukesh Kumar *Sent:* Thursday, September 26, 2013 3:10 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ paste special particular formula ** ** Hi experts, I need a macro code to paste special a particular formula across many sheets. Every sheet contains different types of formulas, but i have to paste special a particular /specific formula. Please help me out. Regards, Mukesh Kumar -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit
$$Excel-Macros$$ to
dear Sir, How can make new member of excel-macros groups. -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ how to unhide multiple sheets at once in excel 2007
Hi Experts, Is there any way to unhide multiple worksheets at once in excel 2007. Please share your inputs. Thanks Regards, Prabhu R -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
