Hi Basole, While testing your application, how can we do the error handling when the numbers are not suppose in the text column? Refer the image as below:-
Thank you. <https://lh4.googleusercontent.com/-yyG9qgr10e0/U0F1wnfs6gI/AAAAAAAAAFg/-0W_obNfhIM/s1600/abc1.jpg> On Sunday, April 6, 2014 11:25:31 PM UTC+8, Falina Gan wrote: > > Hi Basole, > > Thank you for your brilliant codes especially you have identify which > sheets that we need to run the application. May I ask how about the project > name such as ABC.xlsm? > > Secondly, the symbol @ is for any string? > > Thirdly, even we click the stop button at the vba code editor, but the > excel application still runs, any reason? > > Can we put a "temperature or degree column" in for column F? how do we do > it in vba? > > We hope to hear from you. > > > > On Sunday, April 6, 2014 9:22:13 AM UTC+8, Basole wrote: >> >> Hi Falina, >> >> See the attachment >> >> I inserted the explanation in the commentary of the vba code editor. >> Corrected some errors and drafted the macro. >> >> Regards, >> >> Basole. >> >> >> >> >> >> >> 2014-04-05 1:52 GMT-03:00 Falina Gan <fali...@gmail.com>: >> >>> 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...@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.
