Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
Thank you very much Maries On Mon, Feb 13, 2012 at 12:58 PM, Maries talk2mar...@gmail.com wrote: Hi, Try this code: *Sub LacsChange() On Error Resume Next Dim MyCell As Range For Each MyCell In Selection.Cells MyCell.Value = MyCell.Value / 10 Next On Error GoTo 0 End Sub * Regards, MARIES. On Mon, Feb 13, 2012 at 9:59 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear expert, is there any macro code to transfer value only selected cell by running the code? On Fri, Feb 10, 2012 at 6:59 PM, Sam Mathai Chacko samde...@gmail.comwrote: This does exactly what you need http://www.ozgrid.com/forum/showthread.php?t=144212 Regards, Sam Mathai Chacko On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad lakshman...@yahoo.comwrote: Divide from lac =165221/10 (1.65221)** *From:* Ashish Bhalara ashishbhalar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, 10 February 2012 5:34 PM *Subject:* $$Excel-Macros$$ Transfer number in unit Rs.Lacs Dear expert, I require the macro to transfer the number in unit Rs.Lacs. For example the cell which contain number of 165221 then run macro for selected cell and its value transfer to 1.65221 Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem
Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
Dear expert, is there any macro code to transfer value only selected cell by running the code? On Fri, Feb 10, 2012 at 6:59 PM, Sam Mathai Chacko samde...@gmail.comwrote: This does exactly what you need http://www.ozgrid.com/forum/showthread.php?t=144212 Regards, Sam Mathai Chacko On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad lakshman...@yahoo.comwrote: Divide from lac =165221/10 (1.65221)** *From:* Ashish Bhalara ashishbhalar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, 10 February 2012 5:34 PM *Subject:* $$Excel-Macros$$ Transfer number in unit Rs.Lacs Dear expert, I require the macro to transfer the number in unit Rs.Lacs. For example the cell which contain number of 165221 then run macro for selected cell and its value transfer to 1.65221 Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
Hi, Try this code: *Sub LacsChange() On Error Resume Next Dim MyCell As Range For Each MyCell In Selection.Cells MyCell.Value = MyCell.Value / 10 Next On Error GoTo 0 End Sub * Regards, MARIES. On Mon, Feb 13, 2012 at 9:59 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear expert, is there any macro code to transfer value only selected cell by running the code? On Fri, Feb 10, 2012 at 6:59 PM, Sam Mathai Chacko samde...@gmail.comwrote: This does exactly what you need http://www.ozgrid.com/forum/showthread.php?t=144212 Regards, Sam Mathai Chacko On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad lakshman...@yahoo.comwrote: Divide from lac =165221/10 (1.65221)** *From:* Ashish Bhalara ashishbhalar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, 10 February 2012 5:34 PM *Subject:* $$Excel-Macros$$ Transfer number in unit Rs.Lacs Dear expert, I require the macro to transfer the number in unit Rs.Lacs. For example the cell which contain number of 165221 then run macro for selected cell and its value transfer to 1.65221 Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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
Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
Divide from lac =165221/10 (1.65221) From: Ashish Bhalara ashishbhalar...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 10 February 2012 5:34 PM Subject: $$Excel-Macros$$ Transfer number in unit Rs.Lacs Dear expert, I require the macro to transfer the number in unit Rs.Lacs. For example the cell which contain number of 165221 then run macro for selected cell and its value transfer to 1.65221 Thanks regards Ashish Bhalara-- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Transfer number in unit Rs.Lacs
This does exactly what you need http://www.ozgrid.com/forum/showthread.php?t=144212 Regards, Sam Mathai Chacko On Fri, Feb 10, 2012 at 5:45 PM, Lakshman Prasad lakshman...@yahoo.comwrote: Divide from lac =165221/10 (1.65221)** *From:* Ashish Bhalara ashishbhalar...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, 10 February 2012 5:34 PM *Subject:* $$Excel-Macros$$ Transfer number in unit Rs.Lacs Dear expert, I require the macro to transfer the number in unit Rs.Lacs. For example the cell which contain number of 165221 then run macro for selected cell and its value transfer to 1.65221 Thanks regards Ashish Bhalara -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com