Re: $$Excel-Macros$$ Pivot Table - Required percentile values
Thank you Anoop for your hlep but probably for us VBA is a not a solution. Once again many thanks for time and effort. S. On Mon, Nov 19, 2012 at 9:16 AM, Anoop K Sharma aks.sharm...@gmail.comwrote: Possibly, I am getting errors in applying the above criteria. What if I can provide you the same applying VBA? Regards, Anoop Sr. Developer On Tue, Nov 13, 2012 at 10:55 AM, Sheyn Lee sheyn...@gmail.com wrote: Dear Anoop, I need the values from a pivot table use the formula '=PERCENTILE(C2:C6,0.5)' Best Regrds, S. On Mon, Nov 12, 2012 at 12:56 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Sheyn, Please elaborate your query. Regards, Anoop On Sat, Nov 10, 2012 at 2:29 PM, Sheyn Lee sheyn...@gmail.com wrote: Dear MS Excel Group, Can we get percentile values from a pivot table. Best Regards, Sheyn -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Anoop -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Anoop -- 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
Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner.
Done !! Regards, Debaranjan Thanks Regards, *Deba ranjan* On Sun, Nov 18, 2012 at 9:53 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Let's get set for the new year 2013 Here is inviting you to participate in a quiz to make calendar for the new year in excel. There are some rules to be followed : 1) No macros to be used and should be formula based, only xlsx file to be submitted. 2) The calendar should be dynamic for any year, if you change the year , the calendar should update automatically. 3) The calendar should be in one sheet only 4) The leap year should be considered. 5) Last date to submit the calendar is 2nd December 2012 6) Make sure you create calendar yourself and do not download from anywhere 7) Send your calendar to my email id - jainayush85[at]gmail.com. If you post in the forum, there are chances people take reference from your calendar. 8) Once you send the calendar, you can reply to this post for the confirmation. The following will add points to your calendar : 1) Highlight current date 2) Highlight bank/public holidays 3) Calendar formatting and user friendliness There is a prize for the best calendar and recognition for the runner up. Sponsors for the prize are invited, you can contact me if you want to be sponsor. Looking forward to your active participation in the quiz. Let me know if you have any queries. Many thanks for your contribution to this group. Keep it up Regards Ayush Jain Group Manager -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
RE: $$Excel-Macros$$ Type Mismatch error.
Transpose work only on 65536 Rows Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prince Sent: 19 November 2012 11:18 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Type Mismatch error. Hi Group, i am getting type mismatch error while transposing the array of 8 rows and 155206 columns. although same code running fine when no of columns got decreased around 1 below is my line of code in which i m getting error.Please suggest ThisWorkbook.Worksheets(TempContact).Range(A1).Resize(UBound(Application .Transpose(varConsolidate)), 8) = Application.Transpose(varConsolidate) Regards Prince -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Looking for formula to extract hours and minutes
Paul, Your explanation was clear and insightful. You solved my problem. MANY THANKS !! On Friday, November 16, 2012 2:21:21 PM UTC-5, Paul Schreiner wrote: The problem is that Excel doesn't really SEE the hours, minutes, and seconds. What it SEE's is a number. The date: Tuesday, November 13, 2012 16:48:41 is actually a number: (41226.700474537) DISPLAYED any way that you'd like it! This number is the number of days (41226) since 1/1/1900. The decimal portion (.700474537) is the fractional part of a day So, what you're really wanting to do is to round this number off the equivalent of the number of minutes in a day. --- Let's say your date is in cell A2: So, since the number of minuts/day is 24hrs/day * 60min/hr = (24*60) thenthe number of MINUTES in this date is: -- =A2*(24*60) -- The decimal portion of this result represents the fractional part of a minute, or seconds, so we'd like to keep only the integer portion: -- =INT(A2*(24*60)) -- Next, we need to convert it back to days by dividing it by the number of seconds/day: - =INT(A2*(24*60))/(24*60) - the other option is to build the date string like this: =DATE(YEAR(A2),MONTH(A2),DAY(A2)) +TIME(HOUR(A2),MINUTE(A2),0) In this case, the Date() function uses the year/month/day to calculate the INTEGER number of days since 1/1/1900. The time function calculates the fractional part of a day (using 0 seconds) Adding the two together results in a number: in this case: 41226.7 which can be DISPLAYED as a date and time: Tuesday, November 13, 2012 16:48:00 hope this helps. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Bill Q ronsm...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: *Sent:* Fri, November 16, 2012 12:17:53 PM *Subject:* Re: $$Excel-Macros$$ Looking for formula to extract hours and minutes Hi Sam, Thanks for the advice. Yes, I had tried that. Yes, it visually changes it to what I want, but again - the true time still indicates seconds in addition to the hours and minuites. Under normal circumstances this may not be an issue, however I am using a vlookup formula afterwards for further data manipulation. I will unable to get a proper match because it continues to see the seconds. Any other possible ideas ? On Friday, November 16, 2012 11:03:45 AM UTC-5, Sam Mathai Chacko wrote: Why don't you simply format the cell using custom format *h:mm AM/PM Regards, *Sam Mathai Chacko On Fri, Nov 16, 2012 at 9:28 PM, Bill Q ronsm...@gmail.com wrote: Hi, I am looking for a formula that would extract hours and minutes. I want it to ignore the date and seconds and not round the minutes based on the seconds. Preferably wither in military time or with AM?PM so that it can be sortable. Here is the way the data is currently formatted. This is what is visually seen in the cell. 13/11/2012 16:48 This is what is seen when you click on the cell. 13/11/2012 4:48:41 PM What I would prefer to see is either just 16:48 or 4:48 PM Thanks. -- Join official facebook page of this forum @ https://www.facebook.com/ discussexcel https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@ googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Sam Mathai Chacko -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Looking for formula to extract hours and minutes
You're welcome. I realize that I tend to get a little verbose (wordy), but different people learn things differently. I usually try to explain the why instead of simply providing a solution. It takes more time to do it, but hopefully it helps avoid future frustrations. let us know if we can be of further assistance. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Bill Q ronsmith...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, November 19, 2012 9:54:25 AM Subject: Re: $$Excel-Macros$$ Looking for formula to extract hours and minutes Paul, Your explanation was clear and insightful. You solved my problem. MANY THANKS !! On Friday, November 16, 2012 2:21:21 PM UTC-5, Paul Schreiner wrote: The problem is that Excel doesn't really SEE the hours, minutes, and seconds. What it SEE's is a number. The date: Tuesday, November 13, 2012 16:48:41 is actually a number: (41226.700474537) DISPLAYED any way that you'd like it! This number is the number of days (41226) since 1/1/1900. The decimal portion (.700474537) is the fractional part of a day So, what you're really wanting to do is to round this number off the equivalent of the number of minutes in a day. -- - Let's say your date is in cell A2: So, since the number of minuts/day is 24hrs/day * 60min/hr = (24*60) thenthe number of MINUTES in this date is: -- =A2*(24*60) -- The decimal portion of this result represents the fractional part of a minute, or seconds, so we'd like to keep only the integer portion: -- =INT(A2*(24*60)) -- Next, we need to convert it back to days by dividing it by the number of seconds/day: - =INT(A2*(24*60))/(24*60) - the other option is to build the date string like this: =DATE(YEAR(A2),MONTH(A2),DAY( A2)) +TIME(HOUR(A2),MINUTE(A2),0) In this case, the Date() function uses the year/month/day to calculate the INTEGER number of days since 1/1/1900. The time function calculates the fractional part of a day (using 0 seconds) Adding the two together results in a number: in this case: 41226.7 which can be DISPLAYED as a date and time: Tuesday, November 13, 2012 16:48:00 hope this helps. Paul -- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- From: Bill Q ronsm...@gmail.com To: excel-...@googlegroups.com Sent: Fri, November 16, 2012 12:17:53 PM Subject: Re: $$Excel-Macros$$ Looking for formula to extract hours and minutes Hi Sam, Thanks for the advice. Yes, I had tried that. Yes, it visually changes it to what I want, but again - the true time still indicates seconds in addition to the hours and minuites. Under normal circumstances this may not be an issue, however I am using a vlookup formula afterwards for further data manipulation. I will unable to get a proper match because it continues to see the seconds. Any other possible ideas ? On Friday, November 16, 2012 11:03:45 AM UTC-5, Sam Mathai Chacko wrote: Why don't you simply format the cell using custom format h:mm AM/PM Regards, Sam Mathai Chacko On Fri, Nov 16, 2012 at 9:28 PM, Bill Q ronsm...@gmail.com wrote: Hi, I am looking for a formula that would extract hours and minutes. I want it to ignore the date and seconds and not round the minutes based on the seconds. Preferably wither in military time or with AM?PM so that it can be sortable. Here is the way the data is currently formatted. This is what is visually seen in the cell. 13/11/2012 16:48 This is what is seen when you click on the cell. 13/11/2012 4:48:41 PM What I would prefer to see is either just 16:48 or 4:48 PM Thanks. -- Join official facebook page of this forum @ https://www.facebook.com/ discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is
$$Excel-Macros$$ Formula to grab last two words from string
I have a string such as the following two examples and want a formula to grab the last two words. The following formula works for me but I'm looking for other ways to do the same. =MID(A1,FIND(-Date,A1)+6,LEN(A1)) Any help would be appreciated Cell A1 contains: Reporting Period: Month-To-Date November 2012 Reporting Period: Month-To-Date April 2012 Formula in cell B1 should produce: November 2012 April 2012 Thank you! -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Type Mismatch error.
Thanks Rajan On Monday, November 19, 2012 7:09:06 PM UTC+5:30, Rajan_Verma wrote: *Transpose work only on 65536 Rows* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Prince *Sent:* 19 November 2012 11:18 *To:* excel-...@googlegroups.com javascript: *Subject:* $$Excel-Macros$$ Type Mismatch error. Hi Group, i am getting type mismatch error while transposing the array of 8 rows and 155206 columns. although same code running fine when no of columns got decreased around 1 below is my line of code in which i m getting error.Please suggest ThisWorkbook.Worksheets(TempContact).Range(A1).Resize(UBound(Application.Transpose(varConsolidate)), 8) = Application.Transpose(varConsolidate) Regards Prince -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Formula to grab last two words from string
Hi Natron, I hope this will help you. =MID(A1,FIND(*,SUBSTITUTE(A1, ,*,1),1),LEN(A1)) Regards Prince On Monday, November 19, 2012 9:42:53 PM UTC+5:30, Natron wrote: I have a string such as the following two examples and want a formula to grab the last two words. The following formula works for me but I'm looking for other ways to do the same. =MID(A1,FIND(-Date,A1)+6,LEN(A1)) Any help would be appreciated Cell A1 contains: Reporting Period: Month-To-Date November 2012 Reporting Period: Month-To-Date April 2012 Formula in cell B1 should produce: November 2012 April 2012 Thank you! -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
RE: $$Excel-Macros$$ Formula to grab last two words from string
If words are separated by Space use this =TRIM(RIGHT(SUBSTITUTE(A1, ,REPT( ,LEN(A1))),LEN(A1)*2)) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Natron Sent: 19 November 2012 9:43 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Formula to grab last two words from string I have a string such as the following two examples and want a formula to grab the last two words. The following formula works for me but I'm looking for other ways to do the same. =MID(A1,FIND(-Date,A1)+6,LEN(A1)) Any help would be appreciated Cell A1 contains: Reporting Period: Month-To-Date November 2012 Reporting Period: Month-To-Date April 2012 Formula in cell B1 should produce: November 2012 April 2012 Thank you! -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
RE: $$Excel-Macros$$ Re: Formula to grab last two words from string
Is it Extracting 2 words?? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prince Sent: 19 November 2012 9:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Formula to grab last two words from string Hi Natron, I hope this will help you. =MID(A1,FIND(*,SUBSTITUTE(A1, ,*,1),1),LEN(A1)) Regards Prince On Monday, November 19, 2012 9:42:53 PM UTC+5:30, Natron wrote: I have a string such as the following two examples and want a formula to grab the last two words. The following formula works for me but I'm looking for other ways to do the same. =MID(A1,FIND(-Date,A1)+6,LEN(A1)) Any help would be appreciated Cell A1 contains: Reporting Period: Month-To-Date November 2012 Reporting Period: Month-To-Date April 2012 Formula in cell B1 should produce: November 2012 April 2012 Thank you! -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Type Mismatch error.
How are you getting 155,206 columns? In Excel 2010, there can be only 16,384 columns (and 1,048,576 rows) So, there must be an issue with where you're coming up with that number. Paul On Monday, November 19, 2012 12:47:53 AM UTC-5, Prince wrote: Hi Group, i am getting type mismatch error while transposing the array of 8 rows and 155206 columns. although same code running fine when no of columns got decreased around 1 below is my line of code in which i m getting error.Please suggest ThisWorkbook.Worksheets(TempContact).Range(A1).Resize(UBound(Application.Transpose(varConsolidate)), 8) = Application.Transpose(varConsolidate) Regards Prince -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table
Dear experts, is there any solution for pick the step value in certain table? please see above attached workbook here i need formula for pick the value thanks -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. All1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Formula to grab last two words from string
Works Perfectly, Thanks! Rajan On Monday, November 19, 2012 11:40:26 AM UTC-5, Rajan_Verma wrote: *If words are separated by Space use this* *=TRIM(RIGHT(SUBSTITUTE(A1, ,REPT( ,LEN(A1))),LEN(A1)*2))** * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Formula to grab last two words from string
Prince, thank you for the attempt, this does not work as I intended. I'm interested to learn more about the technique you came back with. If you have the time can you do a quick explaination of the functions you are using to arrrive at the result? Thank you again! On Monday, November 19, 2012 11:26:07 AM UTC-5, Prince wrote: Hi Natron, I hope this will help you. =MID(A1,FIND(*,SUBSTITUTE(A1, ,*,1),1),LEN(A1)) Regards Prince -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table
Q: is there any solution for pick the step value in certain table? I'm sure that there is. We can easily give you answers. lots of answers. The problem is, they may not match up to your question. I'm not sure what the purpose or intent is for this. You seem to be highlighting the cell in which the row header and column header are the same. It happens that in the example, this also is where the row NUMBER and column NUMBER are the same, which may or may not be useful. but without knowing how the data is obtained, it's difficult to provide an answer to meet your needs. also, you said you want to pick a step value. HOW do you want to pick it? That is, what do you mean by pick? Do you want a specific cell selected? what criteria is used to select a cell? what constitutes a step? what do you want to do with it when you pick it. Do you want to return the value to a VBA script? Do you want value to appear in a specific cell? Please elaborate. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Renukachari Kasee jva.ch...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, November 19, 2012 12:06:41 PM Subject: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table Dear experts, is there any solution for pick the step value in certain table? please see above attached workbook here i need formula for pick the value thanks -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.
Hi Friends, I have attached the file where I need to export specific range to another excel file which to be save on C: drive. I have created userform for this as well. Need vba code to perform this task. Waiting for the solution. Please help !!! -- With regards, *MaNgEsH* -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. ExportRange.xlsm Description: Binary data
Re: $$Excel-Macros$$ Re: dear experts is there any solution for pick the step value in certain table
I'm sorry, but that doesn't help much. Please keep in mind that this collection of data has significance and meaning to YOU, but is meaningless to just about everyone else. how many accounts are profiled So, somehow these numbers represent accounts. But I have no idea what you mean by profiled. But why are there dates across the top and down the side? Why is the intersection of column E and row 5 significant? (both with headings of May-09) Your statement of in Feb to feb does that mean from February 2009 to February 2010? I still don't understand what the data represents and how to determine what relationship is significant. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Renukachari Kasee jva.ch...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, November 19, 2012 2:13:55 PM Subject: $$Excel-Macros$$ Re: dear experts is there any solution for pick the step value in certain table Hi Mr.Paul, thanks for your replay please see the attcahed workbook onece here in feb to feb how many accounts are profilied in mar to mar how many accounts are profiled . . . . So on I need in the value in row no 15 here I am enter manualy but here data is small so it is possible but my data range was too large on that time month on month profiled calculations are too difficult for me is there any possibility to pick the boxed value in the single row I think it is possible on offset formula but I don’t know how to use it please help me 35, Renukachari Kasee jva.ch...@gmail.com wrote: Dear experts, is there any solution for pick the step value in certain table? please see above attached workbook here i need formula for pick the value thanks -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table
Hi Renu, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Mon, Nov 19, 2012 at 10:35 PM, Renukachari Kasee jva.ch...@gmail.comwrote: Dear experts, is there any solution for pick the step value in certain table? please see above attached workbook here i need formula for pick the value thanks -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. All1(solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.
This is close and might get you a kickstart. Sub selectme() '' 'Original Script Written by www.ozgrid.com '' Dim rRange As Range Dim strCriteria As String, strCriteria2 As String Dim lCol As Long Dim rHeaderCol As Range Dim xlCalc As XlCalculation On Error Resume Next Step1: Set rRange = Range(A1).CurrentRegion 'Cancelled or non valid rage If rRange Is Nothing Then Exit Sub 'Awlays use GoTo when selecting range so doesn't matter which Worksheet Application.Goto rRange.Rows(1), True step2: lCol = 1 'Cancelled If lCol = 0 Then Exit Sub Step3: strCriteria = frmExport.txtStart strCriteria2 = frmExport.txtEnd 'Store current Calculation then switch to manual. 'Turn off events and screen updating With Application xlCalc = .Calculation .Calculation = xlCalculationManual .EnableEvents = False .ScreenUpdating = False End With 'Remove any filters ActiveSheet.AutoFilterMode = False With rRange 'Filter, offset(to exclude headers) .AutoFilter Field:=lCol, Criteria1:== strCriteria, Operator:=XlAutoFilterOperator.xlAnd, Criteria2:== strCriteria2 .Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Select End With 'Remove any filters 'ActiveSheet.AutoFilterMode = False 'Revert back With Application .Calculation = xlCalc .EnableEvents = True .ScreenUpdating = True End With On Error GoTo 0 End Sub On Monday, November 19, 2012 1:55:03 PM UTC-5, Mangesh wrote: Hi Friends, I have attached the file where I need to export specific range to another excel file which to be save on C: drive. I have created userform for this as well. Need vba code to perform this task. Waiting for the solution. Please help !!! -- With regards, *MaNgEsH* -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: Type Mismatch error.
Hi Paul, These numbers of columns in my array.and i wanted to assign this columns after transposing or after making it rows to a range. regards Prince On Monday, November 19, 2012 10:20:40 PM UTC+5:30, Paul Schreiner wrote: How are you getting 155,206 columns? In Excel 2010, there can be only 16,384 columns (and 1,048,576 rows) So, there must be an issue with where you're coming up with that number. Paul On Monday, November 19, 2012 12:47:53 AM UTC-5, Prince wrote: Hi Group, i am getting type mismatch error while transposing the array of 8 rows and 155206 columns. although same code running fine when no of columns got decreased around 1 below is my line of code in which i m getting error.Please suggest ThisWorkbook.Worksheets(TempContact).Range(A1).Resize(UBound(Application.Transpose(varConsolidate)), 8) = Application.Transpose(varConsolidate) Regards Prince -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: Type Mismatch error.
Dear Prince, Pl share a sample workbook with us. Regards, Gawli Anil On Tue, Nov 20, 2012 at 8:42 AM, Prince prince141...@gmail.com wrote: Hi Paul, These numbers of columns in my array.and i wanted to assign this columns after transposing or after making it rows to a range. regards Prince On Monday, November 19, 2012 10:20:40 PM UTC+5:30, Paul Schreiner wrote: How are you getting 155,206 columns? In Excel 2010, there can be only 16,384 columns (and 1,048,576 rows) So, there must be an issue with where you're coming up with that number. Paul On Monday, November 19, 2012 12:47:53 AM UTC-5, Prince wrote: Hi Group, i am getting type mismatch error while transposing the array of 8 rows and 155206 columns. although same code running fine when no of columns got decreased around 1 below is my line of code in which i m getting error.Please suggest ThisWorkbook.Worksheets(**TempContact).Range(A1).** Resize(UBound(Application.**Transpose(varConsolidate)), 8) = Application.Transpose(**varConsolidate) Regards Prince -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.