Re: $$Excel-Macros$$ Repeated row to be deleted
Dear Pravin, Replaced - ActiveSheet.Range($A$1:$AL$85).RemoveDuplicates _ Columns:=3, Header:=xlYes by ActiveSheet.Range($A$1:$AL$85).RemoveDuplicates Columns:=Array(2, 3), _ Header:=xlYes Might help you out. Regards, Chaya On Mon, Apr 15, 2013 at 11:12 AM, Pravin Gunjal isk1...@gmail.com wrote: Hi Chaya It must be check in col. B C and not only C. Pl check and inform. Regards Pravin. On Mon, Apr 15, 2013 at 11:08 AM, Chaya chayamon...@gmail.com wrote: Dear Pravin, Check the below if it will work out. and you can change the row number as you like. e.g. AL85 to AL5000 as per your data. Sub Remove_Duplicate() ' Removing Duplicate in c column. Application.ScreenUpdating = False Sheets(FNDWRR).Select Sheets(FNDWRR).Copy After:=Sheets(1) Sheets(FNDWRR (2)).Name = FNDWRR-Unique Record ActiveSheet.Range($A$1:$AL$85).RemoveDuplicates _ Columns:=3, Header:=xlYes Application.ScreenUpdating = True MsgBox Removed Duplicate in C coloumn, vbInformation, Removed End Sub Regards, Chaya On Sat, Apr 13, 2013 at 10:03 AM, Pravin Gunjal isk1...@gmail.comwrote: Dear Friends I would like to delete the repeated row from the attached sheet. E.g. Row No. 3, 5, 7 and so on up to row no.5000 Can someone help me to this by macro. Thank you, 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Re: $$Excel-Macros$$ print all URL details in a PDF file
still waiting Lakshman Prasad Sr. Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ From: LAKSHMAN PRASAD lakshman_...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Cc: gawlianil8...@gmail.com gawlianil8...@gmail.com Sent: Saturday, April 13, 2013 10:45 AM Subject: Re: $$Excel-Macros$$ print all URL details in a PDF file Dear Anil, I don’t to print excel details, I want to print column D all details after clicked URL, like when I click cell d2 a detail will open, I want print that details. See the attached file. Lakshman Prasad From: अनिल नारायण गवली gawlianil8...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com; lakshman_...@yahoo.com Sent: Friday, April 12, 2013 3:12 PM Subject: Re: $$Excel-Macros$$ print all URL details in a PDF file Dear Lakshman, Pls see the attached sheet. and Kindly run then macro. Warm Regards, Gawli Anil On Fri, Apr 12, 2013 at 2:07 PM, Chaya chayamon...@gmail.com wrote: Dear Lakshman, I got your point, i am not sure i can do, but i can only try as i am a very new learner. After all our experts will surely tackle out this query. Regards, Chaya On Fri, Apr 12, 2013 at 1:14 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear chayaThanks for prompt reply, but I want to print column D all details, like when I click cell d2 a detail will open, I want print that details. See the attached file. Lakshman Prasad From: Chaya chayamon...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Friday, April 12, 2013 1:00 PM Subject: Re: $$Excel-Macros$$ print all URL details in a PDF file Dear Lakshman, If you have a PDF creater Installed, you can use this code, Just i recorded. Sub PrintUrl() Sheets(Sheet1).Select Range(D2:D63).Select Selection.Copy Workbooks.Add ActiveSheet.Paste Application.CutCopyMode = False ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _ IgnorePrintAreas:=False End Sub Regards, Chaya On Fri, Apr 12, 2013 at 12:36 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: Dear expert I have a excel file, in a sheet contain some details with URL, is there any formula add-on or marco to print all URL details in a PDF file. Lakshman Prasad-- 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 mailto:excel-macros%2bunsubscr...@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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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 mailto:excel-macros%2bunsubscr...@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?hl=en. For more options, visit
$$Excel-Macros$$ cell formula
Hi, I am trying to set the formula of a cell to be the following: =D6 YEAR(MonthEndDate) . MONTH(MonthEndDate) . \Outputs\ However the following code gives this forumula instead: = 'D6' YEAR(MonthEndDate) . rg.value . \Outputs\ How can I correct this to give the formula I want? Sub test() Dim sMonthEnd As String Dim iMonthEnd As Integer Dim rg As Range sMonthEnd = Month(Range(MonthEndDate)) Set rg = Range(MonthlyFolders).Find(What:=sMonthEnd).Offset(0, 1) Range(OutputFolder).FormulaR1C1 = =D6 YEAR(MonthEndDate) . rg.value . \Outputs\ 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Number to words
Hi If there any formula in excel to convert a numeric figure into words -- Thanks Regards *CA Abhishek Verma* *ACA, DISA, MBA, B.Com (Hons)* *Partner* *SALUJA ASSOCIATES.* *CHARTERED ACCOUNTANTS* 69,Desh Bandhu Gupta Road, Jolly Building, 2nd Floor Pahar Ganj New Delhi - 110 055. Mobile No. 0-9818-522-747 Email: ave...@salujaandassociates.com Web Site : www.salujaandassociates.com skype : caabhishekverma * * *Think before you print. Go Green.* ** The contents of this e-mail are confidential. If you are not the named addressee or if this transmission has been addressed to you in error, please notify the sender immediately and then delete this e-mail. Any unauthorized copying and transmission is forbidden. E-Mail transmission cannot be guaranteed to be secure. If verification is required, please request a hard copy version. Please note, that incoming email is not checked regularly. This may result in a failure to comply with legal or contractual terms. Therefore it is not sufficient, to sent any legal or contractual declarations by email. In no event will Saluja Associates or named person be liable to you or any third party for any direct, indirect, consequential, special or exemplary damages or lost profit resulting from this failure. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Number to words
Hi Abhishek, PFA by Noorain Sir. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* * * On Mon, Apr 15, 2013 at 1:44 PM, Abhishek Verma ave...@salujaandassociates.com wrote: Hi If there any formula in excel to convert a numeric figure into words -- Thanks Regards *CA Abhishek Verma* *ACA, DISA, MBA, B.Com (Hons)* *Partner* *SALUJA ASSOCIATES.* *CHARTERED ACCOUNTANTS* 69,Desh Bandhu Gupta Road, Jolly Building, 2nd Floor Pahar Ganj New Delhi - 110 055. Mobile No. 0-9818-522-747 Email: ave...@salujaandassociates.com Web Site : www.salujaandassociates.com skype : caabhishekverma * * *Think before you print. Go Green.* ** The contents of this e-mail are confidential. If you are not the named addressee or if this transmission has been addressed to you in error, please notify the sender immediately and then delete this e-mail. Any unauthorized copying and transmission is forbidden. E-Mail transmission cannot be guaranteed to be secure. If verification is required, please request a hard copy version. Please note, that incoming email is not checked regularly. This may result in a failure to comply with legal or contractual terms. Therefore it is not sufficient, to sent any legal or contractual declarations by email. In no event will Saluja Associates or named person be liable to you or any third party for any direct, indirect, consequential, special or exemplary damages or lost profit resulting from this failure. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Convert Number to Text(Excel and VBA Both).xlsm Description: Binary data
Re: $$Excel-Macros$$ Repeated row to be deleted
*Thank Chaya will try with this...* On Mon, Apr 15, 2013 at 11:48 AM, Chaya chayamon...@gmail.com wrote: Dear Pravin, Replaced - ActiveSheet.Range($A$1:$AL$85).RemoveDuplicates _ Columns:=3, Header:=xlYes by ActiveSheet.Range($A$1:$AL$85).RemoveDuplicates Columns:=Array(2, 3), _ Header:=xlYes Might help you out. Regards, Chaya On Mon, Apr 15, 2013 at 11:12 AM, Pravin Gunjal isk1...@gmail.com wrote: Hi Chaya It must be check in col. B C and not only C. Pl check and inform. Regards Pravin. On Mon, Apr 15, 2013 at 11:08 AM, Chaya chayamon...@gmail.com wrote: Dear Pravin, Check the below if it will work out. and you can change the row number as you like. e.g. AL85 to AL5000 as per your data. Sub Remove_Duplicate() ' Removing Duplicate in c column. Application.ScreenUpdating = False Sheets(FNDWRR).Select Sheets(FNDWRR).Copy After:=Sheets(1) Sheets(FNDWRR (2)).Name = FNDWRR-Unique Record ActiveSheet.Range($A$1:$AL$85).RemoveDuplicates _ Columns:=3, Header:=xlYes Application.ScreenUpdating = True MsgBox Removed Duplicate in C coloumn, vbInformation, Removed End Sub Regards, Chaya On Sat, Apr 13, 2013 at 10:03 AM, Pravin Gunjal isk1...@gmail.comwrote: Dear Friends I would like to delete the repeated row from the attached sheet. E.g. Row No. 3, 5, 7 and so on up to row no.5000 Can someone help me to this by macro. Thank you, 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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: Help needed
=MID(A1,(FIND(5,A1)),6) Regards, Vijay On Fri, Apr 12, 2013 at 12:00 PM, Prince prince141...@gmail.com wrote: =IF(LEFT(A1,1)=B,LEFT(A1,6),) On Thursday, April 11, 2013 10:16:28 PM UTC+5:30, Kaushik wrote: Hi Team, I need a formula to find anything starting from 5 in a cell and to take 6 digit right of the cell starting from 5 as below. Eg. DataDesired Result ABC 500012 XYZ 500012 XYZ500134XYZ 500134 Regards, Kaushik -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Vijay Kumar Aggarwal -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Document number to become automatically
Do you want the Doc. No. after you fill column a and c or what and what should be the doc no how we decide. On Monday, 15 April 2013 11:09:35 UTC+5:30, Pravin Gunjal wrote: *Hi, I want the result : Doc. No. to be come when the stockist and location is getting typed in column C A accordingly as per the new stockist. * * * *For every new location I will fix / give the first document no.* [image: Inline image 2] *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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: cell formula
Change this line activecell.FormulaR1C1 = =D6 YEAR(MonthEndDate) . rg.value . \Outputs\ with activecell.Formula = =D6 YEAR(MonthEndDate) . rg.value . \Outputs\ On Monday, 15 April 2013 13:28:30 UTC+5:30, colmkav wrote: Hi, I am trying to set the formula of a cell to be the following: =D6 YEAR(MonthEndDate) . MONTH(MonthEndDate) . \Outputs\ However the following code gives this forumula instead: = 'D6' YEAR(MonthEndDate) . rg.value . \Outputs\ How can I correct this to give the formula I want? Sub test() Dim sMonthEnd As String Dim iMonthEnd As Integer Dim rg As Range sMonthEnd = Month(Range(MonthEndDate)) Set rg = Range(MonthlyFolders).Find(What:=sMonthEnd).Offset(0, 1) Range(OutputFolder).FormulaR1C1 = =D6 YEAR(MonthEndDate) . rg.value . \Outputs\ 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ print all URL details in a PDF file
Please give me some time i am working on this and this can be done. so don't worry man. I will come up with a solution by eod. On Monday, 15 April 2013 12:58:16 UTC+5:30, lakshm...@yahoo.com wrote: still waiting *Lakshman Prasad* Sr. Manager (Finance) GAURSONS INDIA LIMITED Ph: +91 12 456777 Mob. No. 9582279261 Website: http://www.gaursonsindia.com/ *From:* LAKSHMAN PRASAD lakshm...@yahoo.com javascript: *To:* excel-...@googlegroups.com javascript: excel-...@googlegroups.com javascript: *Cc:* gawlia...@gmail.com javascript: gawlia...@gmail.comjavascript: *Sent:* Saturday, April 13, 2013 10:45 AM *Subject:* Re: $$Excel-Macros$$ print all URL details in a PDF file Dear Anil, I don’t to print excel details, I want to print column D all details after clicked URL, like when I click cell d2 a detail will open, I want print that details. See the attached file. *Lakshman Prasad* *From:* अनिल नारायण गवली gawlia...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: excel-...@googlegroups.com javascript:; lakshm...@yahoo.comjavascript: *Sent:* Friday, April 12, 2013 3:12 PM *Subject:* Re: $$Excel-Macros$$ print all URL details in a PDF file Dear Lakshman, Pls see the attached sheet. and Kindly run then macro. Warm Regards, Gawli Anil On Fri, Apr 12, 2013 at 2:07 PM, Chaya chaya...@gmail.com javascript:wrote: Dear Lakshman, I got your point, i am not sure i can do, but i can only try as i am a very new learner. After all our experts will surely tackle out this query. Regards, Chaya On Fri, Apr 12, 2013 at 1:14 PM, LAKSHMAN PRASAD lakshm...@yahoo.comjavascript: wrote: Dear chaya Thanks for prompt reply, but I want to print column D all details, like when I click cell d2 a detail will open, I want print that details. See the attached file. *Lakshman Prasad* *From:* Chaya chaya...@gmail.com javascript: *To:* excel-...@googlegroups.com javascript: excel-...@googlegroups.com javascript: *Sent:* Friday, April 12, 2013 1:00 PM *Subject:* Re: $$Excel-Macros$$ print all URL details in a PDF file Dear Lakshman, If you have a PDF creater Installed, you can use this code, Just i recorded. Sub PrintUrl() Sheets(Sheet1).Select Range(D2:D63).Select Selection.Copy Workbooks.Add ActiveSheet.Paste Application.CutCopyMode = False ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _ IgnorePrintAreas:=False End Sub Regards, Chaya On Fri, Apr 12, 2013 at 12:36 PM, LAKSHMAN PRASAD lakshm...@yahoo.comjavascript: wrote: Dear expert I have a excel file, in a sheet contain some details with URL, is there any formula add-on or marco to print all URL details in a PDF file. *Lakshman Prasad* -- 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 mailto:excel-macros%2bunsubscr...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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
Re: $$Excel-Macros$$ Remove NA Error
Dear Amar, Use , As example =IFERROR(INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0)),) Regards, Chaya On Mon, Apr 15, 2013 at 5:44 PM, amar takale amartak...@gmail.com wrote: Dear All Can anybody tell me how to remove NA from Attached Sheet in Output worksheet.I try with IF ISERROR but not work. Pls Suggest formula for Remove NA show Blank cell. Regards Amar -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ VBA to Open Access When User Has Runtime Access Installed
Hi all, I am stuck, hope someone can help me... I a using the following code in Excel, to open an Access database. It works fine for users with Full Version Access installed however I get an Activex cannot create object error for users who only have Access runtime installed (most users). Is there a way to overcome this issue? I have this golbal declaration... Global appAccess As Object An then this code resides in an onButtonCLick function... Set appAccess = CreateObject(Access.Application) Application.DisplayAlerts = False Set appAccess = GetObject(K:\Folder\Database.mdb) Thanks in advance for your help. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Remove NA Error
Dear Chaya Thanks for Reply suggest formula for Remove NA but it show NAME Error. Pls see it Thanks Amar On Mon, Apr 15, 2013 at 5:53 PM, Chaya chayamon...@gmail.com wrote: Dear Amar, Use , As example =IFERROR(INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0)),) Regards, Chaya On Mon, Apr 15, 2013 at 5:44 PM, amar takale amartak...@gmail.com wrote: Dear All Can anybody tell me how to remove NA from Attached Sheet in Output worksheet.I try with IF ISERROR but not work. Pls Suggest formula for Remove NA show Blank cell. Regards Amar -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Remove NA Error
Dear Chaya Thats perfect formula but I used Excel 2003.So It is not useful for me.Pls suggest for Excel 2003 Supported formula. Thank again for help me Regards Amar On Mon, Apr 15, 2013 at 6:07 PM, Chaya chayamon...@gmail.com wrote: Dear Amar, PFA... On Mon, Apr 15, 2013 at 6:03 PM, amar takale amartak...@gmail.com wrote: Dear Chaya Thanks for Reply suggest formula for Remove NA but it show NAME Error. Pls see it Thanks Amar On Mon, Apr 15, 2013 at 5:53 PM, Chaya chayamon...@gmail.com wrote: Dear Amar, Use , As example =IFERROR(INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0)),) Regards, Chaya On Mon, Apr 15, 2013 at 5:44 PM, amar takale amartak...@gmail.comwrote: Dear All Can anybody tell me how to remove NA from Attached Sheet in Output worksheet.I try with IF ISERROR but not work. Pls Suggest formula for Remove NA show Blank cell. Regards Amar -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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
RE: $$Excel-Macros$$ Remove NA Error
Hi Aamar, Please Try This Formula Hope this will help u =IF(ISERROR(INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0))) ,,INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0))) Regards Priti verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 15 April 2013 6:18 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Remove NA Error Dear Chaya Thats perfect formula but I used Excel 2003.So It is not useful for me.Pls suggest for Excel 2003 Supported formula. Thank again for help me Regards Amar On Mon, Apr 15, 2013 at 6:07 PM, Chaya chayamon...@gmail.com wrote: Dear Amar, PFA... On Mon, Apr 15, 2013 at 6:03 PM, amar takale amartak...@gmail.com wrote: Dear Chaya Thanks for Reply suggest formula for Remove NA but it show NAME Error. Pls see it Thanks Amar On Mon, Apr 15, 2013 at 5:53 PM, Chaya chayamon...@gmail.com wrote: Dear Amar, Use , As example =IFERROR(INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0)),) Regards, Chaya On Mon, Apr 15, 2013 at 5:44 PM, amar takale amartak...@gmail.com wrote: Dear All Can anybody tell me how to remove NA from Attached Sheet in Output worksheet.I try with IF ISERROR but not work. Pls Suggest formula for Remove NA show Blank cell. Regards Amar -- 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 mailto:excel-macros%2bunsubscr...@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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Chaya -- 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 mailto:excel-macros%2bunsubscr...@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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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$$ Fw: Help Needed
Sent from BlackBerry® on Airtel -Original Message- From: Arjun S Gupta agup...@ciansanalytics.com Date: Mon, 15 Apr 2013 18:35:44 To: asha...@gmail.com Subject: Help Needed Hi All, Garden Fresh Restaurant Corp., L+1175 (L+975 Cash/2.00% PIK), 12/11/13 =IF(ISERROR(TRIM(MID(A45,FIND(/,A45)-2,8))),,TRIM(MID(A45,FIND(/,A45)- 2,8))) I am the above formula to extract the date but it gives error because / is there in Cash also. How should I proceed? Thanks in advance! Regards, Arjun Gupta -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Document number to become automatically
*As I mentioned earlier : For every new location I will fix / give the first document no.* * * *e.g. I have given the first Doc. No. for Lucknow, Bangalore, Cochin which should continue...* * * *Thanks.* *Pravin. * On Mon, Apr 15, 2013 at 4:23 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Do you want the Doc. No. after you fill column a and c or what and what should be the doc no how we decide. On Monday, 15 April 2013 11:09:35 UTC+5:30, Pravin Gunjal wrote: *Hi, I want the result : Doc. No. to be come when the stockist and location is getting typed in column C A accordingly as per the new stockist. * * * *For every new location I will fix / give the first document no.* [image: Inline image 2] *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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Fw: Help Needed
Hi Arjun Use this formula =VLOOKUP(??/??/??,TRIM(MID(SUBSTITUTE(A45, ,REPT( ,LEN(A45))),((ROW(INDIRECT(1:LEN(A45)))-1)*LEN(A45))+1,LEN(A45))),1,0) Enter as a array formula Regards Priti verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of asha...@gmail.com Sent: 15 April 2013 6:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fw: Help Needed Sent from BlackBerryR on Airtel _ From: Arjun S Gupta agup...@ciansanalytics.com Date: Mon, 15 Apr 2013 18:35:44 +0530 To: asha...@gmail.com Subject: Help Needed Hi All, Garden Fresh Restaurant Corp., L+1175 (L+975 Cash/2.00% PIK), 12/11/13 =IF(ISERROR(TRIM(MID(A45,FIND(/,A45)-2,8))),,TRIM(MID(A45,FIND(/,A45)- 2,8))) I am the above formula to extract the date but it gives error because / is there in Cash also. How should I proceed? Thanks in advance! Regards, Arjun Gupta -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Fw: Help Needed
Hi Asharfi, If before date ), are fixed Then try =VALUE(RIGHT(C6,LEN(C6)-LEN(LEFT(C6,FIND(),,C6)))-2)) . Enjoy Team XLS On Mon, Apr 15, 2013 at 6:51 PM, asha...@gmail.com wrote: Sent from BlackBerry® on Airtel -- *From: * Arjun S Gupta agup...@ciansanalytics.com *Date: *Mon, 15 Apr 2013 18:35:44 +0530 *To: *asha...@gmail.com *Subject: *Help Needed Hi All, ** ** ** ** Garden Fresh Restaurant Corp., L+1175 (L+975 Cash/2.00% PIK), 12/11/13 ** ** =IF(ISERROR(TRIM(MID(A45,FIND(/,A45)-2,8))),,TRIM(MID(A45,FIND(/,A45)-2,8))) ** ** I am the above formula to extract the date but it gives error because “/” is there in Cash also. How should I proceed? ** ** Thanks in advance! ** ** Regards, Arjun Gupta -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Remove NA Error
Dear Priti Perfect!!!,I got it formula which I want. Thanks very Much... Regards Amar On Mon, Apr 15, 2013 at 6:37 PM, Priti_verma pritiverma1...@gmail.comwrote: Hi Aamar, Please Try This Formula Hope this will help u =IF(ISERROR(INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0))),,INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0))) Regards Priti verma ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *amar takale *Sent:* 15 April 2013 6:18 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Remove NA Error ** ** Dear Chaya Thats perfect formula but I used Excel 2003.So It is not useful for me.Pls suggest for Excel 2003 Supported formula. Thank again for help me Regards Amar ** ** On Mon, Apr 15, 2013 at 6:07 PM, Chaya chayamon...@gmail.com wrote: Dear Amar, ** ** PFA... ** ** On Mon, Apr 15, 2013 at 6:03 PM, amar takale amartak...@gmail.com wrote: Dear Chaya Thanks for Reply suggest formula for Remove NA but it show NAME Error. Pls see it Thanks Amar ** ** On Mon, Apr 15, 2013 at 5:53 PM, Chaya chayamon...@gmail.com wrote: Dear Amar, ** ** Use , As example =IFERROR(INDEX(INDIRECT($C$3!L:L),MATCH($C7,INDIRECT($C$3!K:K),0)),) ** ** Regards, Chaya ** ** On Mon, Apr 15, 2013 at 5:44 PM, amar takale amartak...@gmail.com wrote: Dear All Can anybody tell me how to remove NA from Attached Sheet in Output worksheet.I try with IF ISERROR but not work. Pls Suggest formula for Remove NA show Blank cell. Regards Amar -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. ** ** -- ** ** Regards, ** ** Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. ** ** -- 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
$$Excel-Macros$$ User form Find code to ignore if text box is blank
Hello, I have code that looks to modify a cell when there is a value placed in a user form. My issue is that there are multiple text boxes in the user form and I only want the user form to update the cell if there is a value, but ignore a text box if there is no value. Currently, it will update the cell with value but also update if there is no value by blanking out the cell. I would like the program to change the cell if there is a value in text box, but if text box blank then leave original value intact. Thank you in advance. Sub ALTaxType() 'Alabama Dim wbData As Workbook, ws1 As Worksheet, lngLastRow As Long, r As Long, ans As Variant Set wbData = ThisWorkbook Set ws1 = wbData.Sheets(Sheet1) With ws1 lngLastRow = .Cells.Find(what:=*, After:=.Cells(1, 1), LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row For r = lngLastRow To 2 Step -1 ' Assumes row 1 contains col headers If .Cells(r, A) = Alabama Then ' Populates column G with textboxvalue .Cells(r, G) = frmTx.txtboxAL.Value ' .Rows(r).Delete ' If you want to delete row End If Next r End With 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ print current file to pdf
which version of excel r u using .. can u share a sample file On Sun, Apr 14, 2013 at 7:23 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hello Team I am looking for VBA code to print a active sheet into pdf without user interface. Suppose the cell AA1 contains the address where the pdf to be stored and Cell AA2 contains the name by which the pdf to be stored. -- Regards Santosh santoshkumar.subu...@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 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Fwd: $$Excel-Macros$$ Time Tracking Tracker
Hi All, I am getting error message when I am trying to apply the below macro code:- Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 5) Or (Target.Column = 6) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub Pls suggest on it. Regards, Kaushik Savla -- Forwarded message -- From: KAUSHIK SAVLA savla.kaus...@gmail.com Date: Sat, Apr 6, 2013 at 1:15 PM Subject: Re: $$Excel-Macros$$ Time Tracking Tracker To: excel-macros@googlegroups.com excel-macros@googlegroups.com Hi Paul, I am able to use your VBA Code properly. Just have one quick question, I need to send this to team members and do not want them to know the Password to unprotect so there will be no tampering of data. In your code you have mentioned pwd = Test in 4th line which can be accessible by anyone. Is there any way I will be only knowing the password to unprotect without getting displayed to all. Regards, Kaushik Savla On Fri, Apr 5, 2013 at 8:41 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Thank You for the help. On Friday, April 5, 2013, Paul Schreiner schreiner_p...@att.net wrote: Here's what I did: In the Sheet module, create a double-click event: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim pwd pwd = Test If (Target.Count = 1) Then If (Target.Value X = X) Then If (Target.Column = 4) Or (Target.Column = 5) Then ActiveSheet.Unprotect Password:=pwd ActiveCell.Value = Now() ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowFormattingCells:=True, _ AllowFormattingColumns:=True, _ AllowFormattingRows:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ Password:=pwd End If End If End If End Sub --- I changed the display format of columns D-F to display time. In column F, I entered the formula: =IF(AND(D2,E2),E2-D2,) and copied it down the column. I then changed the format of all cells in the sheet to locked and protected the sheet. As you can see in the macro, I used the password test If you use something else, change the value in the macro. hope this helps Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: KAUSHIK SAVLA savla.kaus...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, April 5, 2013 5:25:11 AM Subject: $$Excel-Macros$$ Time Tracking Tracker Hi Team, I need Time Management Tracker which does the following:- If anyone double click in start time column the time of system get capture automatically which cannot be edited , similarly for end time. Need password protected to enable changes my myself. Regards, Kaushik -- 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,
Re: $$Excel-Macros$$ User form Find code to ignore if text box is blank
Hello, It would be helpful if you could attach the excel sheet also... Regards, Pavithra On Mon, Apr 15, 2013 at 7:48 PM, Thomas Yantorno salestaxconsult...@gmail.com wrote: Hello, I have code that looks to modify a cell when there is a value placed in a user form. My issue is that there are multiple text boxes in the user form and I only want the user form to update the cell if there is a value, but ignore a text box if there is no value. Currently, it will update the cell with value but also update if there is no value by blanking out the cell. I would like the program to change the cell if there is a value in text box, but if text box blank then leave original value intact. Thank you in advance. Sub ALTaxType() 'Alabama Dim wbData As Workbook, ws1 As Worksheet, lngLastRow As Long, r As Long, ans As Variant Set wbData = ThisWorkbook Set ws1 = wbData.Sheets(Sheet1) With ws1 lngLastRow = .Cells.Find(what:=*, After:=.Cells(1, 1), LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row For r = lngLastRow To 2 Step -1 ' Assumes row 1 contains col headers If .Cells(r, A) = Alabama Then ' Populates column G with textboxvalue .Cells(r, G) = frmTx.txtboxAL.Value ' .Rows(r).Delete ' If you want to delete row End If Next r End With 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Number to words
You can also try this http://www.excelfox.com/forum/f12/number-into-words-rupees-45/ On Monday, 15 April 2013 14:08:29 UTC+5:30, Kuldeep Singh wrote: Hi Abhishek, PFA by Noorain Sir. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukri...@gmail.com javascript: || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* * * On Mon, Apr 15, 2013 at 1:44 PM, Abhishek Verma ave...@salujaandassociates.com javascript: wrote: Hi If there any formula in excel to convert a numeric figure into words -- Thanks Regards *CA Abhishek Verma* *ACA, DISA, MBA, B.Com (Hons)* *Partner* *SALUJA ASSOCIATES.* *CHARTERED ACCOUNTANTS* 69,Desh Bandhu Gupta Road, Jolly Building, 2nd Floor Pahar Ganj New Delhi - 110 055. Mobile No. 0-9818-522-747 Email: ave...@salujaandassociates.com javascript: Web Site : www.salujaandassociates.com skype : caabhishekverma * * *Think before you print. Go Green.* ** The contents of this e-mail are confidential. If you are not the named addressee or if this transmission has been addressed to you in error, please notify the sender immediately and then delete this e-mail. Any unauthorized copying and transmission is forbidden. E-Mail transmission cannot be guaranteed to be secure. If verification is required, please request a hard copy version. Please note, that incoming email is not checked regularly. This may result in a failure to comply with legal or contractual terms. Therefore it is not sufficient, to sent any legal or contractual declarations by email. In no event will Saluja Associates or named person be liable to you or any third party for any direct, indirect, consequential, special or exemplary damages or lost profit resulting from this failure. -- 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.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Click Option for Multiple Criteria
Dear Experts I want help all our members of group who solved my issue of Click option. We also use Data validation.But I required Click option on criteria. Appreciate the help Regards Amar -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Click.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Column Reference based on changes in Raw reference
Dear Group, I need your help... I am using SUMIFS formula got a simpler solution. I have listed dates in raws say from 1st Apr to 30th Apr. I also prepared columns with the same date as header in next sheet. I want that if I move from raw 1 to raw 2, I get a reference of column 2 so on... Best Regards, Amit Desai +91 98672 32534 Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.