$$Excel-Macros$$ Error occured during opening the file
Dear expert, There are Error occur during opening the file of Excel found unreadable content in 'File Name'. Do you want to recover the contents of this workbook?. There are also sometime problem create during the opening file and Excel gone to task of Recover of file content and open as [Repaired] file. This file contain many sheets and conditions of also linking of each sheets. To complete the task of copy paste in new work book is so hard to write all conditions macros. Kindly give the proper solution regarding this matter. Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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.
$$Excel-Macros$$ Error occured during opening the file
Dear expert, There are Error occur during opening the file of Excel found unreadable content in 'File Name'. Do you want to recover the contents of this workbook?. There are also sometime problem create during the opening file and Excel gone to task of Recover of file content and open as [Repaired] file. This file contain many sheets and conditions of also linking of each sheets. To complete the task of copy paste in new work book is so hard to write all conditions macros. Kindly give the proper solution regarding this matter. There are also message coming with log file in xml which mention below. ?xml version=1.0 encoding=UTF-8 standalone=yes ? - file:///C:/Users/Ashish/AppData/Local/Temp/error008880_01.xml# recoveryLog xmlns=*http://schemas.openxmlformats.org/spreadsheetml/2006/main http://schemas.openxmlformats.org/spreadsheetml/2006/main* logFileNameerror008880_01.xml/logFileName summaryErrors were detected in file 'D:\Ashish\Share Document\Account Statement from Apr-2014.xlsm'/summary - file:///C:/Users/Ashish/AppData/Local/Temp/error008880_01.xml# removedRecords summary=*Following is a list of removed records:* removedRecordRemoved Records: Object from /xl/printerSettings/printerSettings5.bin part (Print options)/removedRecord /removedRecords /recoveryLog Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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$$ Error occured during opening the file
Save as the file and create links again.. Make you you haven't change the MS Platform version to lower. On Fri, Apr 4, 2014 at 11:43 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear expert, There are Error occur during opening the file of Excel found unreadable content in 'File Name'. Do you want to recover the contents of this workbook?. There are also sometime problem create during the opening file and Excel gone to task of Recover of file content and open as [Repaired] file. This file contain many sheets and conditions of also linking of each sheets. To complete the task of copy paste in new work book is so hard to write all conditions macros. Kindly give the proper solution regarding this matter. There are also message coming with log file in xml which mention below. ?xml version=1.0 encoding=UTF-8 standalone=yes ? - recoveryLog xmlns=*http://schemas.openxmlformats.org/spreadsheetml/2006/main http://schemas.openxmlformats.org/spreadsheetml/2006/main* logFileNameerror008880_01.xml/logFileName summaryErrors were detected in file 'D:\Ashish\Share Document\Account Statement from Apr-2014.xlsm'/summary - removedRecords summary=*Following is a list of removed records:* removedRecordRemoved Records: Object from /xl/printerSettings/printerSettings5.bin part (Print options)/ removedRecord /removedRecords /recoveryLog Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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, 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/d/optout.
Re: $$Excel-Macros$$
http://www.doc2pdf.net/Excel2PDF/ http://www.pdftoexcel.org/ http://www.pdfconverter.com/pdf-to-excel-online-free/ https://www.pdftoexcelonline.com/ On Fri, Apr 4, 2014 at 2:27 PM, Neeraj Chauhan neerajchauhan...@gmail.comwrote: Dear expert, I want to convert from PDF to Excel we have some more attachment Kindly provide any softerware to convert. [image: Description: Description: image001] *Neeraj Chauhan* *+91-9756706350 %2B91-9756706350* -- http://www.avast.com/ This email is free from viruses and malware because avast! Antivirushttp://www.avast.com/protection is active. -- 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, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-8586978644 || naukrikuld...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* -- 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. inline: image001.jpg
$$Excel-Macros$$ Re: Question on My Menu !!
Ashish Sir, In My menu - Select Range Can you please add Select non-blank option. Actually I've posted a question on repetitive formatting I'm not getting any reply. If I've that option in My Menu probably I could have asked the same. Attached is the excel which I've shared with group members. Kindly help me to solve this issue. With Regards, Suyog On Sunday, 28 October 2012 13:10:35 UTC+5:30, Suyog Kulkarni wrote: Hello All, I'm using Ashish Sir's My Menu ver 1.6 very frequently that increased my working speed in excel. I'm really thankful for same. Please refer attached my question regarding insert option of my menu. Please advice on my question. With Best Regards, Suyog -- 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. Steps for Good look.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$
Dear , Given information sites are not working. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kuldeep Singh Sent: Friday, April 04, 2014 2:31 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ http://www.doc2pdf.net/Excel2PDF/ http://www.pdftoexcel.org/ http://www.pdfconverter.com/pdf-to-excel-online-free/ https://www.pdftoexcelonline.com/ On Fri, Apr 4, 2014 at 2:27 PM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear expert, I want to convert from PDF to Excel we have some more attachment Kindly provide any softerware to convert. Description: Description: image001 Neeraj Chauhan +91-9756706350 tel:%2B91-9756706350 _ http://www.avast.com/ This email is free from viruses and malware because avast! Antivirus http://www.avast.com/ protection is active. -- 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, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-8586978644 || naukrikuld...@gmail.com || Please Consider the environment. Please don't print this e-mail unless you really need to. -- 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. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- 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. image001.jpg
$$Excel-Macros$$ Coordinating questions for today's QA with the Excel Developers. Let's ask for VBA!
Hello! Today there's a QA with the Excel developers in Reddit (Friday, April 4 at 1:00pm PDT/4:00pm EDT on reddit). We don't usually have a chance to give feedback since the Microsoft Connect initiative doesn't contemplate Office, and they won't even take bug reports from users; their attention is mostly on the big corporate users and no the analysts. So I though we should try to coordinate some questions about the worst parts of Excel. Here's what I think are the things that need the most attention, presented as questions for the Excel Dev team: *1. When will you update the 20 years old VBA Editor to something more modern? *The need for VBA won’t go again even if you ignore it! *2. When do you plan to improve the scripting tools, adding things like modern .net operators, string and table methods, etc? *Apps for Office, VSTO and ExcelDNA all address different needs than those of the vast VBA community, which is mostly comprised of analysts scripting solving for special cases, or SMBs in which the switch to another technology wouldn’t make sense cost-wise (and who you won’t hear given the lack ways of providing feedback for Excel). We can't use Apps for Office for the kind of problems we solve here! Proprietary coding for multiple users in a large enterprise = bad, proprietary coding for analysis = GREAT! *3. When will you begin accepting bug reports and feature requests from the whole Excel community?* There’s no way to provide feedback for the Excel/Office team unless you’re a big MSFT partner; Excel/Office is one of the products without presence in Microsoft Connect. There’s little software that won’t take feedback from its community, and Excel’s is large! 4. Will you add new worksheet functions? Even if Excel is the superior product, there are a lot of community UDFs and functions introduced by Google Spreadsheets that are great additions. For instance, see some of the formulas that Google has and we're missing out: the REGEXEXTRACT, REGEX*, SPLIT... text formulas, the filter formulas (UNIQUE, SORT….), the XPath scrapping functions (IMPORTHTML), the data sources functions (IMPORTDATA...) *5. When will you improve Excel’s charting abilities for analysts and fix the old, old bugs that have yet to get attention? *They are lacking, often requiring a lot of manual “hacking” to achieve results; look at the amount of MVPs that dedicate themselves at explaining such hacks in their blogs. The Excel community has documented over the years TONS of bugs and shortcomings of Excel charting but instead of addressing those you only take care of the big partners requests which are biased towards only a part of the user base.There’s a lot of stuff that comes to mind: LINE CHART GAPS FOR ERRORS OR “”!!!, cycle plots, dynamic data ranges, pattern fills, labelling that stays in its place even if you change the data range, fixing the many problems with date category axis, the inability to accurately select a specific point in a time series where many are drawn, such as a daily series spanning years; the impossibility of easily applying filters to charts such as displaying a level series as a % change over a year ago; the incredible difficulty of highlighting specific time spans in charts; candle charts; the manual labour required to display chart labels to the right of the last observation of a series with the proper formatting; the difficulty in going from a series to the source data range etc etc. I hope you agree that this is an opportunity we shouldn't pass. 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/d/optout.
$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code
Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value *Range(A1:I100).Select* With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Made by Suyog Kulkarni *End Sub* On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote: Hello All, Refer attached excel, I've tried to develop macro using recording for repetitive formatting. Now my problem is how can I assign range for all Non-blank cell. Because my current will work only upto Row 13 Column I. How can assign the code which can work till last row column which contain text / value. Short cut for macro is Ctrl+q. I need this to improve productivity you all can save my lot of time. I generate daily more than 50 reports of 100+ rows. This formatting takes time. Regards, Suyog -- 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.
$$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code
Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value *Range(A1:I100).Select* With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Made by Suyog Kulkarni *End Sub* On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote: Hello All, Refer attached excel, I've tried to develop macro using recording for repetitive formatting. Now my problem is how can I assign range for all Non-blank cell. Because my current will work only upto Row 13 Column I. How can assign the code which can work till last row column which contain text / value. Short cut for macro is Ctrl+q. I need this to improve productivity you all can save my lot of time. I generate daily more than 50 reports of 100+ rows. This formatting takes time. Regards, Suyog -- 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.
$$Excel-Macros$$ How to identify which is text, integers, date, time in a table?
To Whom It May Concern, May I ask, how to you create a vba to identify whether the text or integer or date or time in a table such as:- 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/d/optout.
Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code
Hi, try this: x = Cells(Rows.Count, A).End(xlUp).Row y = Cells(x, Columns.Count).End(xlToLeft).Column Range(A1: Cells(x, y).Address).Select Regards, Basole. 2014-04-04 11:17 GMT-03:00 Suyog Kulkarni nashi...@gmail.com: Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value *Range(A1:I100).Select* With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Made by Suyog Kulkarni *End Sub* On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote: Hello All, Refer attached excel, I've tried to develop macro using recording for repetitive formatting. Now my problem is how can I assign range for all Non-blank cell. Because my current will work only upto Row 13 Column I. How can assign the code which can work till last row column which contain text / value. Short cut for macro is Ctrl+q. I need this to improve productivity you all can save my lot of time. I generate daily more than 50 reports of 100+ rows. This formatting takes time. Regards, Suyog -- 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.
Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values
Rashid Sir, I have made some changes. Now you can change your input column to any column in the sheet and output will be 3 column forward and 1 row down from the input data.. If you require data in different column other then this then change offset value as per your requirement inside the loop. Also please ensure that you data should always start from first row i.e. in first row headings and then required data. Hope this helps. Regards, On Thu, Apr 3, 2014 at 6:40 PM, prkhan56 prkha...@gmail.com wrote: Hello Vicky, Your solution works as per the current set of Data. (Col G H for input) (Col L M for output) I was looking for a solution which should work for any two adjacent columns. Is that possible? I will run the macro from say Values in Col A then it should work for Cols A and B...if Col S then it should work for Col S and T... The output, if required can be on a new sheet Thanks for your time and help On Thursday, April 3, 2014 12:03:07 AM UTC+4, Vicky wrote: Rashid Sir, Hope attached will help? On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan prkh...@gmail.com wrote: Dear All, I am using Excel 2010. I have attached a sample file with my problem. Please see before and after Any macro help would be appreciate. Regards Rashid -- 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...@googlegroups.com. To post to this group, send email to excel-...@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. -- 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
Re: $$Excel-Macros$$
Below attached my suggestions: 1 - A small application (A-PDF Text Extractor) to convert pdf to txt. 2 - Macro that imports the file (M M Price list.txt) to excel. https://www.dropbox.com/s/y0xtlhgjbjgy0qb/Files.rar Regards, Basole. 2014-04-04 6:37 GMT-03:00 Neeraj Chauhan neerajchauhan...@gmail.com: Dear , Given information sites are not working. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kuldeep Singh *Sent:* Friday, April 04, 2014 2:31 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ http://www.doc2pdf.net/Excel2PDF/ http://www.pdftoexcel.org/ http://www..pdfconverter.com/pdf-to-excel-online-free/http://www.pdfconverter.com/pdf-to-excel-online-free/ https://www.pdftoexcelonline.com/ On Fri, Apr 4, 2014 at 2:27 PM, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear expert, I want to convert from PDF to Excel we have some more attachment Kindly provide any softerware to convert. [image: Description: Description: image001] *Neeraj Chauhan* *+91-9756706350 %2B91-9756706350* -- http://www.avast.com/ This email is free from viruses and malware because avast! Antivirushttp://www.avast.com/protection is active. -- 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, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-8586978644 || naukrikuld...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* -- 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-macroshttp://groups.google.com/group/excel-macros . For more options, visit https://groups.google.com/d/optout. -- http://www.avast.com/ This email is free from viruses and malware because avast! Antivirushttp://www.avast.com/protection is active. -- 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
$$Excel-Macros$$ Compare two worksheet Trial Balance
Dear Excel gurus, Every day I have to compare two identical formatted worksheet trial balance. I want macro to compare both the trial balance. Macro should work as below: It will give me an option to choose which two workbook contains (workbook only contains one worksheet containing trial balance). Both Work book contains data like below: TB 1st April G/L code. Amount 10005632. -100 20004128. 50 30008721. -50 40007214. 100 TB 2nd April G/L code. Amount 10005632. -100 10009841. -10 20004128. 60 30008721. -50 40007214. 100 I used to compare both the sheet with vlookup and prepare report like below Changes in TB G/L code. Amount. Mode Change 10009841. -10. New code 20004128.10. Change in amount (sorry for reason of confidentiality I can't share file with you all. I hope you all understand) If any one can help me out to automate the report I will be highly grateful. Thanks in advance. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- 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$$ Re: Need help for repetative formatting - Repair my code
Hi Basole, It's working fine now following are the only problems remaining. 1. While creating macro, I have assigned ctrl+q shortcut which is not working now 2. How can we save the code as Add In or can we add any buttom in existing toolbar ? so I that I can share the same with my co-workers. I can't see, save as option in vba window. Pl help. Thanks to all group members, because of you all I made this code. With Regards, Suyog *Below is the modified code. * Sub ReportWriter() ' Format Macro ' ' Keyboard Shortcut: Ctrl+q ' ' This lines are two fill white color Cells.Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorDark1 .TintAndShade = 0 .PatternTintAndShade = 0 End With ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value x = Cells(Rows.Count, A).End(xlUp).Row y = Cells(x, Columns.Count).End(xlToLeft).Column Range(A1: Cells(x, y).Address).Select With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Code by Suyog Kulkarni End Sub On Saturday, 5 April 2014 02:32:12 UTC+5:30, Basole wrote: Hi, try this: x = Cells(Rows.Count, A).End(xlUp).Row y = Cells(x, Columns.Count).End(xlToLeft).Column Range(A1: Cells(x, y).Address).Select Regards, Basole. 2014-04-04 11:17 GMT-03:00 Suyog Kulkarni nash...@gmail.com javascript: : Hello All, I made my first macro code. Kindly review. Now only problem remain is instead of *Range(A1:I100), I want excel to choose last row last column which contain text/value.* PL help. Regards, Suyog Below is my code *Sub Format()* ' Format Macro ' Keyboard Shortcut: Ctrl+q ' This is range for Report Headings Range(A1:I4).Select Selection.ClearContents With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Selection.Merge ' This is range for Report Header Line Range(A5:I5).Select With Selection.Interior .Color = 13434879 Selection.Font.Bold = True End With ' This is total non blank area of any report. Or Cell range with Text/value *Range(A1:I100).Select* With Selection.Borders .LineStyle = xlContinuous .Weight = xlThin End With Cells.Select With Selection.Interior Selection.Font.Name = Calibri Selection.Font.Size = 11 Selection.Font.ThemeFont = xlThemeFontMinor End With Cells.Select Selection.Columns.AutoFit With Selection .VerticalAlignment = xlCenter .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With Range(A5).Select ActiveWorkbook.Save MsgBox Formatting is done. Only add project details properly., vbOKOnly, Made by Suyog Kulkarni *End Sub* On Friday, 4 April 2014 15:11:52 UTC+5:30, Suyog Kulkarni wrote: Hello All, Refer attached excel, I've tried to develop macro using recording for repetitive formatting. Now my problem is how can I assign range for all Non-blank cell. Because my current will work only upto Row 13 Column I. How can assign the code which can work till last row column which contain text / value. Short cut for macro is Ctrl+q. I need this to improve productivity you all can save my lot of time. I generate daily more than 50 reports of 100+ rows. This formatting takes time. Regards, Suyog -- 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
$$Excel-Macros$$ Re: How to identify which is text, integers, date, time in a table?
Thanks Basole, The codes are running well but can I ask from your codes for my understanding as a learner. Could you explain as below:- 1) z = sheet1.Range(a1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row 2) Set cl = .Cells(i, 1) 3) Case IsEmpty(cl) Case InStr(cl.NumberFormat, :mm) 0 Range(e sheet1.Range(e1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl 4) Range(c sheet1.Range(c1).Offset(sheet1.Rows.Count - 1, 0).End(xlUp).Row + 1) = cl 5) If a user key in a data, for example, today's date, does it affect the codes as well? Hope to hear from your good solutions. On Friday, April 4, 2014 11:41:19 PM UTC+8, Falina Gan wrote: To Whom It May Concern, May I ask, how to you create a vba to identify whether the text or integer or date or time in a table such as:- 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/d/optout.
$$Excel-Macros$$ Delete button on Sequence Column
To Whom It May Concern, Could you guide me with VBA codes, on these steps:- 1) Create a sequence column as image below ( all in alphabets ) 2) Delete button to delete the sequence column 3) Then the pattern column is in A column. ( refer to your right side ) Hope to hear from you. Thanks https://lh3.googleusercontent.com/-Hz697YMgPPM/Uz-NmT7WsNI/AEc/DDx5v2sFrMY/s1600/pattern.jpg -- 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.
$$Excel-Macros$$ How to define the uppercase, lowercase and proper()
To Whom It May Concern, We would like to know if we are creating a column for uppercase, lowercase and initial case like the image as below: https://lh3.googleusercontent.com/-W-ODtj0Qj54/Uz-WLZMSBRI/AEw/milNQIqxnk4/s1600/upper.jpg Hope to hear from you soon. 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/d/optout.
$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()
To Whom It May Concern, In VBA please. thanks. On Saturday, April 5, 2014 1:38:03 PM UTC+8, Falina Gan wrote: To Whom It May Concern, We would like to know if we are creating a column for uppercase, lowercase and initial case like the image as below: https://lh3.googleusercontent.com/-W-ODtj0Qj54/Uz-WLZMSBRI/AEw/milNQIqxnk4/s1600/upper.jpg Hope to hear from you soon. 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/d/optout.