$$Excel-Macros$$ Please Point error in following UDF
Hi I had made this UDF based on the needs of a question asked in this forum. However when i change anything in VBA code (as minute as adding comments or add a point to debug etc. ) the calculated value becomes zero on the worksheet. Also the function does not update automatically when input data is changed. The function value becomes zero when i change the input to function. Please let me know what I have done wrong in this coding. Thank you -- 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/d/optout. customized average.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ FW: Automatically Generating Report - URGENT
Dear friends pls help me. Pls find Attached file and do the needful urgent basis... -Original Message- From: Kannan V vt_kan...@camsonline.com Sent: 10-07-2015 07:15 AM To: kannan.ex...@gmail.com kannan.ex...@gmail.com Subject: Fw: Automatically Generating Report - URGENT Dear Friends, Kindly find the enclosed attachment and do the needful urgent basis. Regards Kannan V 8148746107 -- 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/d/optout. SAMPLE FORMAT.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ FW: Automatically Generating Report - URGENT
Dear friends pls help me. Pls find Attached file and do the needful urgent basis... -Original Message- From: Kannan V vt_kan...@camsonline.com Sent: 10-07-2015 07:15 AM To: kannan.ex...@gmail.com kannan.ex...@gmail.com Subject: Fw: Automatically Generating Report - URGENT Dear Friends, Kindly find the enclosed attachment and do the needful urgent basis. Regards Kannan V 8148746107 -- 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/d/optout. SAMPLE FORMAT.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Change the date in required format in macro and store in variable
Dear team, Need a help on storing the date in the required format in macro. I can able to do but i showing the current date not the actual date. Please find the attached file for your reference. Thanks Regards, Ganesh N -- 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/d/optout. doubt.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable
PFA -- Thanks Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Thu, Jul 9, 2015 at 12:15 PM, Ganesh N ganeshg...@gmail.com wrote: Dear team, Need a help on storing the date in the required format in macro. I can able to do but i showing the current date not the actual date. Please find the attached file for your reference. Thanks Regards, Ganesh N -- 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/d/optout. -- 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/d/optout. doubt.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ Re: Need to print text properly alligned in excel
Dear MandeepBaluja, You are absolutely right i need data in this way bu slightly different then your invoice. I have illustrated my problem more clearly, hope now you can easily understand my problem give me solution. For any further query plz ask to me. Thanks Regards Muhammad Rafique Ujjan On 7/6/15, Mandeep Baluja rockerna...@gmail.com wrote: If I am not wrong you want this type of data.It can easily achieved with the help of formula even the salary slips can be printed automatically with coding. Confirm once if this type of data is required and in case of other scenario you can provide your much data so that I can understand the trend of values. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Monday, July 6, 2015 at 11:38:19 AM UTC+5:30, MRafique Ujjan wrote: Dear sir the text to column option does not work for me, i have already used this tool but doesn't give desired result. On 7/6/15, GENIUS izhar...@gmail.com javascript: wrote: for this purpose you may use TEXT TO COLUMN from DATA ribbon On Friday, 3 July 2015 15:41:43 UTC+5, MRafique Ujjan wrote: Dear Excel Experts! I am facing a problem while print 100s of payslips, problem is that its data is written in one cell which contains text and numerical data. they are not aligned and when i try to set its aligment through space it still not aligned when i take its print. I have attached a sample file. plz go through my problem and assist me to get rid of this problem. Your cooperation in this regard will be highly appreciated. Thanks Muhammad Rafique Ujjan -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/nBrXmtl2fjU/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- -- *Muhammad Rafique Ujjan* Social Organizer Strengthening Participatory Organization (SPO) -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/nBrXmtl2fjU/unsubscribe. To unsubscribe from this group and all its topics, 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/d/optout. -- -- *Muhammad Rafique Ujjan* Social Organizer Strengthening Participatory Organization (SPO) -- 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
$$Excel-Macros$$ link the cell with different sheet
Dear Sir, I want a macro, the macro which has keyboard shortcut associated with it, will entering any data in cell, if shortcut Key is pressed the list of internal sheet shows and selecting the one sheet from the list it will ask the cell reference with which the cell is to be link. In short, I want the macro to link the cell with different sheet Regards, Kumar Bhanushali DISCLAIMER The information contained in this e-mail including attachment is meant only for the addressee and may contain confidential and privileged information. Any use, distribution, printing, retransmission, dissemination, copying or disclosure of this e-mail by any other person is strictly prohibited and may be unlawful. If you are not the intended recipient and receive this e-mail in error, please notify the sender by reply e-mail and then permanently delete this message. Electronic transmission cannot be guaranteed to be secured. Accordingly, PMC Projects (I) Pvt Ltd does not accept liability for any data loss, corruption, interception, unauthorised amendment, viruses, delays or consequences thereof. -- 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/d/optout.
Re: $$Excel-Macros$$ is it possible to reduce this sorting code
Sub MULTI_LEVEL_SORT() '1ST level SORT ON NAME COL A '2ND level SORT ON START DATE COL B '3RD levle SORT ON END DATE COL C Sheets(Sample).Range(a1:d Sheets(Sample).Range(a1).End(xlDown).Row).Sort _ key1:=Sheets(Sample).Range(A:A), order1:=xlAscending, _ key2:=Sheets(Sample).Range(B:B), order2:=xlAscending, _ key3:=Sheets(Sample).Range(C:C), order3:=xlAscending, _ Header:=xlYes End Sub On Thu, Jul 9, 2015 at 3:55 PM, Rohit Jadhav rohitj...@gmail.com wrote: Hi I want to sort a range say a1 to j15 containing various details of one's mutual fund portfolio like company name, fund name, fund type, no of units held, NAV , dividend received etc. I have created sorting code from excel but is it possible to reduce this code. I am using a separate function for sorting as shown below passing it 2 parameters viz. name of the sheet containing data how to sort the data i.e. by value or by fund name. Also if anyone can explain the 2nd part of the sorting code is it necessary to do this part, I would be very thankful. - Sub sorting_Needs() Dim i As String, j As Integer abb: i = InputBox(Do you want to Chr(10) _ 1. sort data by value Chr(10) _ 2. Sort data by name, Choice, 1) Select Case i Case Is = 1 j = sort_data(Sheet1, Range(I:I)) Case Is = 2 j = sort_data(Sheet1, Range(b:b)) Case Else i = MsgBox(Please select a valid choice, vbRetryCancel, Error Massage) If i = 4 Then GoTo abb End If End Select End Sub Public Function sort_data(sh As String, col As Range) 'activate the data sheet Sheets(sh).Activate 'select the entire data table in the sheet Range(A1).Select Selection.CurrentRegion.Select 'code generated by excel for sorting a range ActiveWorkbook.Worksheets(sh).Sort.SortFields.Clear ActiveWorkbook.Worksheets(sh).Sort.SortFields.Add Key:=col _ , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal '2nd part With ActiveWorkbook.Worksheets(sh).Sort .SetRange Range(A1:j12) .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Function -- 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/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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$$ is it possible to reduce this sorting code
Hi I want to sort a range say a1 to j15 containing various details of one's mutual fund portfolio like company name, fund name, fund type, no of units held, NAV , dividend received etc. I have created sorting code from excel but is it possible to reduce this code. I am using a separate function for sorting as shown below passing it 2 parameters viz. name of the sheet containing data how to sort the data i.e. by value or by fund name. Also if anyone can explain the 2nd part of the sorting code is it necessary to do this part, I would be very thankful. - Sub sorting_Needs() Dim i As String, j As Integer abb: i = InputBox(Do you want to Chr(10) _ 1. sort data by value Chr(10) _ 2. Sort data by name, Choice, 1) Select Case i Case Is = 1 j = sort_data(Sheet1, Range(I:I)) Case Is = 2 j = sort_data(Sheet1, Range(b:b)) Case Else i = MsgBox(Please select a valid choice, vbRetryCancel, Error Massage) If i = 4 Then GoTo abb End If End Select End Sub Public Function sort_data(sh As String, col As Range) 'activate the data sheet Sheets(sh).Activate 'select the entire data table in the sheet Range(A1).Select Selection.CurrentRegion.Select 'code generated by excel for sorting a range ActiveWorkbook.Worksheets(sh).Sort.SortFields.Clear ActiveWorkbook.Worksheets(sh).Sort.SortFields.Add Key:=col _ , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal '2nd part With ActiveWorkbook.Worksheets(sh).Sort .SetRange Range(A1:j12) .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Function -- 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/d/optout.