Re: $$Excel-Macros$$ Macro for Copy Paste
On Wed, 7/26/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017, 10:11 AM On Wed, 7/26/17, Shrinivas Shevde wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017, 7:26 AM Can Anyone please help me? On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas Shevde wrote: Dear All I have a work book which contain many daywise sheet in which I maintain machinewise data.I have 20 machines all machines are not running daily so if machine is not running I hide that rows and machine running will be visible.There is down time for a machine having many reasons which are captured in different rows but the machine no and other in merge cell.Now I want to manke a single sheet where I will get all daywise data.See the attached fileI tried it manually but it will take lot of time.Can Anyone will write macro.see "required output sheet" -- Shrini -- 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+unsubscribe@ googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/ group/excel-macros. For more options, visit https://groups.google.com/d/ optout. -- Shrini -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. xersat in tara in lungi si complicate procese isi gaseste aici o noua confirmare -- 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 VB
Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value
On Fri, 7/7/17, Puttu * wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" Date: Friday, July 7, 2017, 2:18 PM Hi Swapnil, Just to let you know all your comments should be based on the error code. Error Code column 1 2 3 all these three has different error description. Thanks Putta On Thu, Jul 6, 2017 at 7:14 PM, Puttu * wrote: Hi Swapnil, Thanks you so much appreciate your time and help on getting this macro. I think got almost what required, there is only small changes, which need to be done. Sorry its my mistake not giving right information on that. The reason I am looking a macro is I can't educate others who are very beginning stage of learning. Macro will be more easier for them to use than conditional formatting. I have added my comments in Final Tab. Please review and let me know if any points are unclear. Thanks Putta On Wed, Jul 5, 2017 at 2:18 PM, Swapnil Palande wrote: Hi, Why are you not using conditional formatting. If your main purpose is to display user duplicates and empty cells, conditional formatting is best solution. Have applied both solutions (conditional formatting as well as macro) in attached excel. Regards, Swapnil. On Wed, Jul 5, 2017 at 12:24 AM, Puttu * wrote: anyhelp please On Tue, Jul 4, 2017 at 12:33 PM, Puttu * wrote: Thanks Sir, Formula match exactly my requirement, however I have more than 50 columns, quite difficult to input formula for every column. Thus the reason I am looking for macro. Please help On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande wrote: Hi, No need of macro, you can do it using formulas also. Attached is the excel for your reference. Regards, Swapnil On Tue, Jul 4, 2017 at 10:36 AM, Puttu * wrote: Experts, Any help on this will be much appreciated On Mon, Jul 3, 2017 at 10:33 PM, Puttu * wrote: Hi Experts Please help on this. Thanks Putta On Mon, Jul 3, 2017 at 9:42 PM, Puttu * wrote: Hi Experts, I am not a vba expert and need your help me on the attached requirement. I have list of columns and from that I need to know based on the Model No. column filter if the other columns have any duplicate values, if yes then it should display comments column as Column Name + duplicate value (Ex: Category_description having duplicate value) 2. If the any of the column is blank it should print Column Name is blank (Ex: Parent Category ID has blank value). Attached is the sample spread sheet. Please review and help me on it. -- Putta -- 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/discu ssexcel 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+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/op tout. -- Putta -- Putta -- 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/discu ssexcel 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 A
Re: $$Excel-Macros$$ Stop the code from Running when Selecting Row
On Mon, 6/5/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Stop the code from Running when Selecting Row To: "excel-macros@googlegroups.com" Date: Monday, June 5, 2017, 9:21 PM From the looks of your macro, I think we need to help understand the SelectionChange event. #1: the "Selection" is passed to the event sub through the "Target" variable.So.. Target IS Selection! It is an array, but a single cell gets passed as an array of (1). What I usually do is cycle through the selection by using: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Targ As Range For Each Targ In Target '... ' ' Next Targend sub Second: [B2:B25] is not a legal construct.You're probably looking for: Range("B2:B25") Now, to your question. If you select an entire row, Target.Count will be a count of all the cells in the row.For Excel 2007 and beyond, that is 256. So, you COULD add: If (Target.Count > 100) then exit sub 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 - On Monday, June 5, 2017 1:36 PM, Carlisle Flores-Garay wrote: I have this file from a previous discussion and I was wondering if there is a way to stop the code from running when I select the whole row so that I can copy and paste without having the window pop up every time. Thank you! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. 51ai celei mici si mijlocii - intelectuali juristi invatatori avocati industriasi reprezentanti ai minoritatilor nationale. -- 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.
Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
On Sat, 4/15/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Saturday, April 15, 2017, 9:57 AM On Fri, 4/14/17, 'Storey Thomas' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Friday, April 14, 2017, 9:07 PM On Fri, 4/14/17, 'Regine Silvers' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Friday, April 14, 2017, 6:25 PM On Fri, 4/14/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Friday, April 14, 2017, 1:00 PM On Thu, 4/13/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Thursday, April 13, 2017, 7:02 PM On Thu, 4/13/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: excel-macros@googlegroups.com Date: Thursday, April 13, 2017, 4:49 PM On Thu, 4/13/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB To: "excel-macros@googlegroups.com" Date: Thursday, April 13, 2017, 2:49 PM Here's the approach I took:I defined a "public" Dictionary object called Dict_Category.I created a function to load the Dict_Category with the category listing from the "DATA" sheet. Being a "public" variable, the values are retained while the workbook is open. I created two worksheet events:Worksheet_SelectionChangeWorksheet_Change I created two events so that the Comments update when the cell is selected, and also if you were to copy/paste several cells into column "A". Personally, I think the Change event is the only one that is required. The Update_Comments function does things like:- Clears the comments from cells that are blank- Shows a message if a value is entered that is not in the Dictionary hope this gives you something to work from. 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 - On Thursday, April 13, 2017 5:26 AM, sunil lobo wrote: hi [U][SIZE=5]just want to have comments populate when the cell is selected based on the lookup/vlookup function through VB[/SIZE][/U]two sheet 1) master_sheet 2 )data sheet masters sheet being dynamic data sheet is staticmaster sheet continuosly changing now when a particular cell is activated by using mouse or keyboard comments should pop-up getting the value from the next data sheet eg: master sheet , cell a2= 1 cell a3=2 cell a4=4so on and so forth in data sheet , cell a2= 5 , cell b2= present a3=2, cell b3= absent a4= 3,cell b4= leave a5= 1, cell b5= leftnow when i select a3 cell in master_sheet i need to populate a comment as [B]absent
Re: $$Excel-Macros$$ Re: Macros for screenshot
On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 11:06 PM On Sat, 4/8/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 10:51 PM On Sat, 4/8/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 9:11 PM On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 7:49 PM On Sat, 4/8/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 8:18 PM On Sat, 4/8/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 5:28 PM On Sat, 4/8/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 2:57 PM On Sat, 4/8/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 2:53 PM On Sat, 4/8/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 10:13 AM On Sat, 4/8/17, priti verma wrote: Subject: Re: $$Excel-Macros$$ Re: Macros for screenshot To: excel-macros@googlegroups.com Date: Saturday, April 8, 2017, 9:03 AM first you need to open that excel file and activate that particular excel file by using application.actiavte "workbbok name" and paste into excel file in desired range. On Fri, Mar 31, 2017 at 4:40 PM, suresh k wrote: Experts any inputs for the below requirement? On 23-Mar-2017 1:43 pm, "suresh k" wrote: Hi All, I have 10 files in my c drive. I have to capture other applications screenshot and paste in all 10 files. I am able to capture screenshot, but not able to paste in 10 excel file. Please suggest macro to paste screenshot in all files Regards, Suresh -- 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 a
Re: $$Excel-Macros$$ Formula to convert Text into Number
On Fri, 4/7/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 10:08 PM On Fri, 4/7/17, 'Keisha Fry' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 8:59 PM On Fri, 4/7/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 3:13 PM On Fri, 4/7/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 9:21 AM On Fri, 4/7/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 9:14 AM On Fri, 4/7/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 4:59 AM On Thu, 4/6/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 6:34 PM On Thu, 4/6/17, 'Martin George' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 6:27 PM On Thu, 4/6/17, jmothilal wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 1:36 PM first letter is not zero is "O" , so Remove the first letter "O", On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: Hi Experts, I am stuck with one problem. I have one file which have numbers in it. but while capturing they got stored as Text. Now i want any formula to convert into normal Text. also there look like another space in the cell but when i try to remove it backspace, last digit of number got deleted. like it is showing as 1234 but is is not in number format and give False in ISNUMBER formula. I have tried converting by cell formatting but it doesn't work. File attached for Example pls help. -- Pankaj Pandey Bhopal -- 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 questi
Re: $$Excel-Macros$$ Formula to convert Text into Number
On Fri, 4/7/17, 'Keisha Fry' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 8:59 PM On Fri, 4/7/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 3:13 PM On Fri, 4/7/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 9:21 AM On Fri, 4/7/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 9:14 AM On Fri, 4/7/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Friday, April 7, 2017, 4:59 AM On Thu, 4/6/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 6:34 PM On Thu, 4/6/17, 'Martin George' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 6:27 PM On Thu, 4/6/17, jmothilal wrote: Subject: Re: $$Excel-Macros$$ Formula to convert Text into Number To: excel-macros@googlegroups.com Date: Thursday, April 6, 2017, 1:36 PM first letter is not zero is "O" , so Remove the first letter "O", On Thu, Apr 6, 2017 at 3:09 PM, Secret Shot wrote: Hi Experts, I am stuck with one problem. I have one file which have numbers in it. but while capturing they got stored as Text. Now i want any formula to convert into normal Text. also there look like another space in the cell but when i try to remove it backspace, last digit of number got deleted. like it is showing as 1234 but is is not in number format and give False in ISNUMBER formula. I have tried converting by cell formatting but it doesn't work. File attached for Example pls help. -- Pankaj Pandey Bhopal -- 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 "
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Wed, 4/5/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 6:25 AM On Wed, 4/5/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 5:28 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 4:19 AM On Wed, 4/5/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 3:39 AM On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:26 AM On Wed, 4/5/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:15 AM ---- On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:37 PM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 6:09 PM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 10:38 AM ---------------- On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM -------------------- On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Cu
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Wed, 4/5/17, 'Carmelita Cronin' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:26 AM On Wed, 4/5/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Wednesday, April 5, 2017, 1:15 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:37 PM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 6:09 PM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 10:38 AM -------- On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM ------------ On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Codi
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 6:09 PM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 10:38 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- 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
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 10:38 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 9:21 AM On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- 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 a
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Tue, 4/4/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 8:01 AM On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- 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 grou
Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA
On Tue, 4/4/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 5:48 AM On Tue, 4/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Tuesday, April 4, 2017, 1:42 AM On Mon, 4/3/17, 'Derrick Andrew' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 5:12 PM On Mon, 4/3/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 4:59 PM On Mon, 4/3/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: excel-macros@googlegroups.com Date: Monday, April 3, 2017, 1:53 PM On Mon, 4/3/17, Hitesh Kr. Aoul wrote: Subject: Re: $$Excel-Macros$$ Re: Customized Inventory Software Required in Excel VBA To: "MS EXCEL AND VBA MACROS" Date: Monday, April 3, 2017, 5:44 AM Hello Guys, Can anyone have any idea how to do the perfect Coding for this type of software... Waiting for the positive reply... On Wednesday, March 29, 2017 at 5:32:50 PM UTC+5:30, Hitesh Kr. Aoul wrote:Hello Learner, Thanks for the reply. Please find the attachment, for material IN form i need subform as there are 100 items in Per Invoice to be enter. Kindly check and if anything else required please discuss. Regards,Hitesh On Wednesday, March 29, 2017 at 2:58:11 PM UTC+5:30, learner wrote:Hi Hitesh, There are many solutions for inventory data. If you want customized solution, you need to specify input and output data and the report forms to be generated. Attach a file giving basic structure Learner On Tue, Mar 28, 2017 at 12:30 PM, Hitesh Kr. Aoul wrote: Hello Guys, Can anyone have any idea how to do the Coding for this type of software... Waiting for the positive reply... -- 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 https://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. Po