Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell
Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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. -- Thanks Regards Gaurav Devrani -- Thanks Regards Gaurav Devrani -- 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. Illustration (1).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell
Yes Sure.. I will get back to you with that formula. No worries. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Gaurav, Thank you for you help. Quick question, is there a way of using a formula instead of a code to do what you have done. Maybe an If statement of some sort. Would appreciate if that were possible. I really need a formula. On Mon, Feb 23, 2015 at 4:42 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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. -- Thanks Regards Gaurav Devrani -- Thanks Regards Gaurav Devrani -- 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. -- *Enock Wangila,* *Intern Analyst* *Umati Capital Ltd* *Eden Square * *Block 1, 7th Floor* *P.O Box 856-00606* *Mobile: +254 708 037 464* *Email: ekwang...@gmail.com ekwang...@gmail.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
$$Excel-Macros$$ Formula to populate cells and sum in adjacent cell
Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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. Illustration.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Formula to populate cells and sum in adjacent cell
HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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. -- Thanks Regards Gaurav Devrani -- 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. Illustration (1).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Computer Login Logout Time Record
Thank you for your reply. I have full access of my computer, there is no restriction of IT. I will try for it. On Wed, Feb 18, 2015 at 6:22 PM, Paul Schreiner schreiner_p...@att.net wrote: Do you have admin privileges for the machine? Windows has policies that you can assign to a machine. These Policies can be used to create startup/exit scripts that write to log files. That's the cleanest way to handle it. There's also a way to query the Win32_NTLogEvent Then search through that log to find what you're looking for. I don't have any way to try this on an XP machine. try googling: SELECT * FROM Win32_NTLogEvent WHERE logfile = and see what you get. *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:* Pravin Gunjal isk1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, February 18, 2015 7:21 AM *Subject:* $$Excel-Macros$$ Computer Login Logout Time Record *Hello Friends,* *I need to have a file which may record the Login Logout time of computer. I am using Windows XP.* *Thanks in anticipation.* *Regards* *Pravin Gunjal* -- 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/1auoU5csZpk/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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.
$$Excel-Macros$$ Excel Tip
Convert all date in same format: While receiving data from different sources many time it happens that data received is not in same format due to various reason. One of the tedious activity is to transforming data to same format. I will share very good technique to convert all dates to same format, suppose you have date in one column A it has different format viz dd-mm- or -mm-dd (it should be in d-m-y or y-m-d format). In column B write formula in cell B1, =A1*1 drag down; you can see all dates will get converted in same format in column b. Also you can apply paste special multiply by 1 operation on data in column A if you don't want to get result through help of column. Also you can perform data text to column operation of column A, select data type as Delimited, delimiter type Tab, data format General. Do share me if you have discovered unique method/trick. Cheers!! -- 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$$ Formula to populate cells and sum in adjacent cell
Try this in B5 of sheet2 and drag right. =IF((COLUMN()-1)=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),)) On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Yes Sure.. I will get back to you with that formula. No worries. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Gaurav, Thank you for you help. Quick question, is there a way of using a formula instead of a code to do what you have done. Maybe an If statement of some sort. Would appreciate if that were possible. I really need a formula. On Mon, Feb 23, 2015 at 4:42 PM, Gaurav Devrani gauravdev1...@gmail.com wrote: Hi , I guess you also want to merge the header cells in sheet 2 for all entries.. Please refer to this new sheet. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: HI Enock, Please check the attached file and let me know if I missed something. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila ekwang...@gmail.com wrote: Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with a value of 100 and sum the cell entries in the adjacent cell to give 900. The operations of populating and summing should be contained in a single formula. I have attached an excel file for illustration. Cheers, -- 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. -- Thanks Regards Gaurav Devrani -- Thanks Regards Gaurav Devrani -- 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. -- *Enock Wangila,* *Intern Analyst* *Umati Capital Ltd* *Eden Square * *Block 1, 7th Floor* *P.O Box 856-00606* *Mobile: +254 708 037 464* *Email: ekwang...@gmail.com ekwang...@gmail.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)
Re: $$Excel-Macros$$ Converting excel files to .txt format with delimiter comma
Option Explicit Sub export_range_delimit() Dim arr As Variant Dim fs As Object Dim delimittxt Dim i As Long Dim j As Long Dim line As String Dim rng As Range Dim delimittype As String delimittype = , Set fs = CreateObject(Scripting.FileSystemObject) Set delimittxt = fs.CreateTextFile(C:\Users\xx\Desktop\ delimit.txt, True) Set rng = Sheet1.Range(a1:b17) arr = rng For j = LBound(arr) To UBound(arr) line = For i = 1 To rng.Columns.Count line = line delimittype arr(j, i) Next delimittxt.WriteLine Right(line, Len(line) - 1) Next delimittxt.Close Set delimittxt = Nothing Set fs = Nothing End Sub see if it helps On Mon, Feb 23, 2015 at 9:47 PM, ashish koul koul.ash...@gmail.com wrote: Do you wanna export range in comma delimit text file?. On Mon, Feb 23, 2015 at 9:38 PM, Muneera Shabana muneera.shab...@gmail.com wrote: Hello there, I have written a macro to convert xls files to text file, however I have 2 problems here: 1. My code doesnot show xlsx format to pick up from the source folder 2. I am not sure when to add the code to have delimiter comma in my text file. I am not an expert, so seeking support from you guys, please help!! Sub XLS_to_TXT() Dim wb As Workbook Dim SourcePath As String Dim strFile As String, strDir As String Dim newpath As String Dim k Dim q Dim j Set j = Application.FileDialog(msoFileDialogFolderPicker) j.Show SourcePath = j.SelectedItems(1) SourcePath = SourcePath \ '// SourcePath = H:\Macros\ strFile = Dir(SourcePath *.xlsx) Do While strFile Set wb = Workbooks.Open(Filename:=SourcePath strFile, Local:=True) newpath = H:\Macros\csv\ k = Replace(wb.FullName, .xlsx, .txt) q = Replace(k, SourcePath, newpath) wb.SaveAs q wb.Close True Set wb = Nothing strFile = Dir Loop MsgBox The files are successfully converted into text format placed in target folder Application.Wait (Now + TimeValue(00:00:02)) ActiveWorkbook.FollowHyperlink newpath End Sub -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to
$$Excel-Macros$$ Auto clear content
Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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$$ Converting excel files to .txt format with delimiter comma
Hello there, I have written a macro to convert xls files to text file, however I have 2 problems here: 1. My code doesnot show xlsx format to pick up from the source folder 2. I am not sure when to add the code to have delimiter comma in my text file. I am not an expert, so seeking support from you guys, please help!! Sub XLS_to_TXT() Dim wb As Workbook Dim SourcePath As String Dim strFile As String, strDir As String Dim newpath As String Dim k Dim q Dim j Set j = Application.FileDialog(msoFileDialogFolderPicker) j.Show SourcePath = j.SelectedItems(1) SourcePath = SourcePath \ '// SourcePath = H:\Macros\ strFile = Dir(SourcePath *.xlsx) Do While strFile Set wb = Workbooks.Open(Filename:=SourcePath strFile, Local:=True) newpath = H:\Macros\csv\ k = Replace(wb.FullName, .xlsx, .txt) q = Replace(k, SourcePath, newpath) wb.SaveAs q wb.Close True Set wb = Nothing strFile = Dir Loop MsgBox The files are successfully converted into text format placed in target folder Application.Wait (Now + TimeValue(00:00:02)) ActiveWorkbook.FollowHyperlink newpath End Sub -- 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$$ Converting excel files to .txt format with delimiter comma
Do you wanna export range in comma delimit text file?. On Mon, Feb 23, 2015 at 9:38 PM, Muneera Shabana muneera.shab...@gmail.com wrote: Hello there, I have written a macro to convert xls files to text file, however I have 2 problems here: 1. My code doesnot show xlsx format to pick up from the source folder 2. I am not sure when to add the code to have delimiter comma in my text file. I am not an expert, so seeking support from you guys, please help!! Sub XLS_to_TXT() Dim wb As Workbook Dim SourcePath As String Dim strFile As String, strDir As String Dim newpath As String Dim k Dim q Dim j Set j = Application.FileDialog(msoFileDialogFolderPicker) j.Show SourcePath = j.SelectedItems(1) SourcePath = SourcePath \ '// SourcePath = H:\Macros\ strFile = Dir(SourcePath *.xlsx) Do While strFile Set wb = Workbooks.Open(Filename:=SourcePath strFile, Local:=True) newpath = H:\Macros\csv\ k = Replace(wb.FullName, .xlsx, .txt) q = Replace(k, SourcePath, newpath) wb.SaveAs q wb.Close True Set wb = Nothing strFile = Dir Loop MsgBox The files are successfully converted into text format placed in target folder Application.Wait (Now + TimeValue(00:00:02)) ActiveWorkbook.FollowHyperlink newpath End Sub -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+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$$ mouseover on list of item in combobox
Possible to show a toltiptext on mouse over on each items of combobox? Note: combobox is on a vba useform -- 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: mouseover on list of item in combobox
*Hi Sal Sal,* Please find the attached macro file. Regards, MV On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote: Possible to show a toltiptext on mouse over on each items of combobox? Note: combobox is on a vba useform -- 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. Mouseover Macro.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Auto clear content
Hi Ahmad, Please follow my instructions to clear what do you want, Steps: 1. Goto to Excel page, Press CTRL+F11 2. After that, in the left hand side shows the sheets menu, Double click that after paste the following code. *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* *Dim r As Range* *Set r = Selection* *r.ClearContents* *End Sub* Its clear the what ever you want. If you need more details, please contact me @ +91 9894585740 / bsureshkumar2...@gmail.com Thanks and Regards, Suresh Kumar.B On Monday, February 23, 2015 at 11:15:49 PM UTC+5:30, Ahmad Mustfa wrote: Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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: Auto clear content
Thanks Kumar. Can you please send me in the excel file. i am trying but unable to understand to how to do that. On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B bsureshkumar2...@gmail.com wrote: Hi Ahmad, Please follow my instructions to clear what do you want, Steps: 1. Goto to Excel page, Press CTRL+F11 2. After that, in the left hand side shows the sheets menu, Double click that after paste the following code. *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* *Dim r As Range* *Set r = Selection* *r.ClearContents* *End Sub* Its clear the what ever you want. If you need more details, please contact me @ +91 9894585740 / bsureshkumar2...@gmail.com Thanks and Regards, Suresh Kumar.B On Monday, February 23, 2015 at 11:15:49 PM UTC+5:30, Ahmad Mustfa wrote: Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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, Ahmad Mustafa +44 7768197568 -- 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: Auto clear content
Hi Ahmad, Here you go!!! By, Suresh Kumar.B On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote: Thanks Kumar. Can you please send me in the excel file. i am trying but unable to understand to how to do that. On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B bsureshk...@gmail.com javascript: wrote: Hi Ahmad, Please follow my instructions to clear what do you want, Steps: 1. Goto to Excel page, Press CTRL+F11 2. After that, in the left hand side shows the sheets menu, Double click that after paste the following code. *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* *Dim r As Range* *Set r = Selection* *r.ClearContents* *End Sub* Its clear the what ever you want. If you need more details, please contact me @ +91 9894585740 / bsureshk...@gmail.com javascript: Thanks and Regards, Suresh Kumar.B On Monday, February 23, 2015 at 11:15:49 PM UTC+5:30, Ahmad Mustfa wrote: Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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 javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards, Ahmad Mustafa +44 7768197568 -- 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. Clear Contents Excel by SUKU.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: Auto clear content
Thanks kumar. how you did that. i am still confused? how i can use in my work? can you please have online chat with me. On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B bsureshkumar2...@gmail.com wrote: Hi Ahmad, Here you go!!! By, Suresh Kumar.B On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote: Thanks Kumar. Can you please send me in the excel file. i am trying but unable to understand to how to do that. On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B bsureshk...@gmail.com wrote: Hi Ahmad, Please follow my instructions to clear what do you want, Steps: 1. Goto to Excel page, Press CTRL+F11 2. After that, in the left hand side shows the sheets menu, Double click that after paste the following code. *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* *Dim r As Range* *Set r = Selection* *r.ClearContents* *End Sub* Its clear the what ever you want. If you need more details, please contact me @ +91 9894585740 / bsureshk...@gmail.com Thanks and Regards, Suresh Kumar.B On Monday, February 23, 2015 at 11:15:49 PM UTC+5:30, Ahmad Mustfa wrote: Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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. -- Regards, Ahmad Mustafa +44 7768197568 -- 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, Ahmad Mustafa +44 7768197568 -- 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
Re: $$Excel-Macros$$ Re: Auto clear content
i want this in a specific column not on all sheet On Mon, Feb 23, 2015 at 7:40 PM, Ahmad Mustfa ahmadmus...@gmail.com wrote: Thanks kumar. how you did that. i am still confused? how i can use in my work? can you please have online chat with me. On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B bsureshkumar2...@gmail.com wrote: Hi Ahmad, Here you go!!! By, Suresh Kumar.B On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote: Thanks Kumar. Can you please send me in the excel file. i am trying but unable to understand to how to do that. On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B bsureshk...@gmail.com wrote: Hi Ahmad, Please follow my instructions to clear what do you want, Steps: 1. Goto to Excel page, Press CTRL+F11 2. After that, in the left hand side shows the sheets menu, Double click that after paste the following code. *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* *Dim r As Range* *Set r = Selection* *r.ClearContents* *End Sub* Its clear the what ever you want. If you need more details, please contact me @ +91 9894585740 / bsureshk...@gmail.com Thanks and Regards, Suresh Kumar.B On Monday, February 23, 2015 at 11:15:49 PM UTC+5:30, Ahmad Mustfa wrote: Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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. -- Regards, Ahmad Mustafa +44 7768197568 -- 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, Ahmad Mustafa +44 7768197568 -- Regards, Ahmad Mustafa +44 7768197568 -- 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
Re: $$Excel-Macros$$ Re: Auto clear content
kumar i got it what you sent. it's open with alt+f11 not ctrl+f11 now i want this only one specific column not on all sheet. can you please send formula for that On Mon, Feb 23, 2015 at 7:43 PM, Ahmad Mustfa ahmadmus...@gmail.com wrote: i want this in a specific column not on all sheet On Mon, Feb 23, 2015 at 7:40 PM, Ahmad Mustfa ahmadmus...@gmail.com wrote: Thanks kumar. how you did that. i am still confused? how i can use in my work? can you please have online chat with me. On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B bsureshkumar2...@gmail.com wrote: Hi Ahmad, Here you go!!! By, Suresh Kumar.B On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote: Thanks Kumar. Can you please send me in the excel file. i am trying but unable to understand to how to do that. On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B bsureshk...@gmail.com wrote: Hi Ahmad, Please follow my instructions to clear what do you want, Steps: 1. Goto to Excel page, Press CTRL+F11 2. After that, in the left hand side shows the sheets menu, Double click that after paste the following code. *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* *Dim r As Range* *Set r = Selection* *r.ClearContents* *End Sub* Its clear the what ever you want. If you need more details, please contact me @ +91 9894585740 / bsureshk...@gmail.com Thanks and Regards, Suresh Kumar.B On Monday, February 23, 2015 at 11:15:49 PM UTC+5:30, Ahmad Mustfa wrote: Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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. -- Regards, Ahmad Mustafa +44 7768197568 -- 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, Ahmad Mustafa +44 7768197568 -- Regards, Ahmad Mustafa +44 7768197568 -- Regards, Ahmad Mustafa +44 7768197568 -- 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
Re: $$Excel-Macros$$ Excel Tip
Superb Vaibhav. Thanks for sharing this with us. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht csb.bi...@gmail.com wrote: Hi. Very nice... Thankx Rgds, Chandra Singh Bisht On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi v...@vabs.in wrote: Convert all date in same format: While receiving data from different sources many time it happens that data received is not in same format due to various reason. One of the tedious activity is to transforming data to same format. I will share very good technique to convert all dates to same format, suppose you have date in one column A it has different format viz dd-mm- or -mm-dd (it should be in d-m-y or y-m-d format). In column B write formula in cell B1, =A1*1 drag down; you can see all dates will get converted in same format in column b. Also you can apply paste special multiply by 1 operation on data in column A if you don't want to get result through help of column. Also you can perform data text to column operation of column A, select data type as Delimited, delimiter type Tab, data format General. Do share me if you have discovered unique method/trick. Cheers!! -- 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. -- Thanks Regards Gaurav Devrani -- 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$$ Help required
Dear experts, I want to some of times as given below format 2/1/2015 2/21/2015 sum in Hours Like 11:39:49 9:42:15 9 hrs 30 Minute -- 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$$ FW: Help required
Dear experts, I want to SUM of time as given below format 2/1/2015 2/21/2015 sum in Hours Like 11:39:49 9:42:15 9 hrs 30 Minute From: Neeraj [mailto:neerajchauhan...@gmail.com] Sent: Tuesday, February 24, 2015 10:11 AM To: 'excel-macros@googlegroups.com' Subject: Help required Dear experts, I want to some of times as given below format 2/1/2015 2/21/2015 sum in Hours Like 11:39:49 9:42:15 9 hrs 30 Minute -- 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$$ Excel Tip
Hi. Very nice... Thankx Rgds, Chandra Singh Bisht On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi v...@vabs.in wrote: Convert all date in same format: While receiving data from different sources many time it happens that data received is not in same format due to various reason. One of the tedious activity is to transforming data to same format. I will share very good technique to convert all dates to same format, suppose you have date in one column A it has different format viz dd-mm- or -mm-dd (it should be in d-m-y or y-m-d format). In column B write formula in cell B1, =A1*1 drag down; you can see all dates will get converted in same format in column b. Also you can apply paste special multiply by 1 operation on data in column A if you don't want to get result through help of column. Also you can perform data text to column operation of column A, select data type as Delimited, delimiter type Tab, data format General. Do share me if you have discovered unique method/trick. Cheers!! -- 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$$ Re: Auto clear content
Hi Try this..put this code in worksheet module for which this to be work, this will delete content of column 3, you can set to desired column: *Private Sub Worksheet_SelectionChange(ByVal Target As Range)Columns(3).ClearContents 'clears content of column 3End Sub* *Cheers!!* *O*n Tue, Feb 24, 2015 at 1:17 AM, Ahmad Mustfa ahmadmus...@gmail.com wrote: kumar i got it what you sent. it's open with alt+f11 not ctrl+f11 now i want this only one specific column not on all sheet. can you please send formula for that On Mon, Feb 23, 2015 at 7:43 PM, Ahmad Mustfa ahmadmus...@gmail.com wrote: i want this in a specific column not on all sheet On Mon, Feb 23, 2015 at 7:40 PM, Ahmad Mustfa ahmadmus...@gmail.com wrote: Thanks kumar. how you did that. i am still confused? how i can use in my work? can you please have online chat with me. On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B bsureshkumar2...@gmail.com wrote: Hi Ahmad, Here you go!!! By, Suresh Kumar.B On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote: Thanks Kumar. Can you please send me in the excel file. i am trying but unable to understand to how to do that. On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B bsureshk...@gmail.com wrote: Hi Ahmad, Please follow my instructions to clear what do you want, Steps: 1. Goto to Excel page, Press CTRL+F11 2. After that, in the left hand side shows the sheets menu, Double click that after paste the following code. *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* *Dim r As Range* *Set r = Selection* *r.ClearContents* *End Sub* Its clear the what ever you want. If you need more details, please contact me @ +91 9894585740 / bsureshk...@gmail.com Thanks and Regards, Suresh Kumar.B On Monday, February 23, 2015 at 11:15:49 PM UTC+5:30, Ahmad Mustfa wrote: Hi All. I am working in excel sheets . I want to automatically delete/clear text in a cell range. i am not expert enough to do that. Can anyone please help me. Thanks -- Regards, Ahmad Mustafa +44 7768197568 -- 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. -- Regards, Ahmad Mustafa +44 7768197568 -- 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, Ahmad Mustafa +44 7768197568 -- Regards, Ahmad Mustafa +44 7768197568 -- Regards, Ahmad Mustafa +44 7768197568 -- 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
Re: $$Excel-Macros$$ FW: Help required
Dear neeraj, PFA, Regards, Ganesh N On Tue, Feb 24, 2015 at 10:40 AM, Neeraj neerajchauhan...@gmail.com wrote: Dear experts, I want to SUM of time as given below format *2/1/2015* *2/21/2015* *sum in Hours* *Like* 11:39:49 9:42:15 9 hrs 30 Minute *From:* Neeraj [mailto:neerajchauhan...@gmail.com] *Sent:* Tuesday, February 24, 2015 10:11 AM *To:* 'excel-macros@googlegroups.com' *Subject:* Help required Dear experts, I want to some of times as given below format *2/1/2015* *2/21/2015* *sum in Hours* *Like* 11:39:49 9:42:15 9 hrs 30 Minute -- 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. sam1.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Please solve this
-- 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. Book1.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Importing data from Access changes worksheet name
Hi all, I'm pulling data from an Access DB query table. When I do, it changes the name of the active worksheet and I don't want that. How to I pull the data but keep the tab name as it was? Here's the code I'm using: ChDir G:\Work Program\2015 Workbooks.OpenDatabase Filename:= _ G:\Work Program\2015\Temp.accdb, CommandText:=Array( _ qry_TimesheetData), CommandType:=xlCmdTable, ImportDataAs:=xlTable Running Excel 2010 under Win7 Thanks (BTW, if there's a clever way to get the data from the DB I'm all for it.) Tony -- 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.