Re: $$Excel-Macros$$ no of sheets in a workbook
Dear Amit, Try it.. *Application.OnKey %{+}, short_key * Sub short_key() MsgBox Sheets.Count End Sub You can change combination % for Alt (^) for Ctrl (+) for Shift -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 10, 2012 at 11:11 AM, amitkmr amitjanku...@gmail.com wrote: Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Mails IDs from Outlook
Dears, i m facing run time error 1004 For Each oitem In myItems Sheets(Inbox Scan).Cells(i, 1).Value = oitem.SenderName Sheets(Inbox Scan).Cells(i, 2).Value = oitem.SenderEmailAddress 'Sheets(Inbox Scan).Cells(i, 3).Value = oitem.Subject 'Sheets(Inbox Scan).Cells(i, 4).Value = oitem.Body 'Sheets(Inbox Scan).Cells(i, 5).Value = oitem.ReceivedTime i = i + 1 Next End Sub On Mon, Jul 9, 2012 at 4:08 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Rohan, Please check Microsoft outlook 12.0 object Library. See attached screen shot. On Fri, Jul 6, 2012 at 10:11 AM, Rohan Young rohan.j...@gmail.com wrote: Dear Ashish Ji, thanks but i m not getting the result, can you please send me the add in or anything else for it regds ROHAN On Thu, Jul 5, 2012 at 10:58 PM, ashish koul koul.ash...@gmail.com wrote: try this see if it helps Sub Scan_my_outlook_inbox() 'TOOLS -Refrence - microsoft outlook 'declare outlook objects Dim olapp As Outlook.Application Dim olappns As Outlook.Namespace Dim oinbox As Outlook.Folder Dim oitem As Outlook.MailItem Dim myItems As Outlook.Items Dim i As Long i = 2 'set outlook objects Set olapp = New Outlook.Application Set olappns = olapp.GetNamespace(MAPI) ' it will scan inbox folder only Set oinbox = olappns.GetDefaultFolder(olFolderInbox) ' sort emails on recieved basis Set myItems = oinbox.Items myItems.Sort [Received], True 'loop through all unread emails For Each oitem In myItems Sheets(Inbox Scan).Cells(i, 1).Value = oitem.SenderName Sheets(Inbox Scan).Cells(i, 2).Value = oitem.SenderEmailAddress 'Sheets(Inbox Scan).Cells(i, 3).Value = oitem.Subject 'Sheets(Inbox Scan).Cells(i, 4).Value = oitem.Body 'Sheets(Inbox Scan).Cells(i, 5).Value = oitem.ReceivedTime i = i + 1 Next End Sub On Thu, Jul 5, 2012 at 4:39 PM, Rohan Young rohan.j...@gmail.com wrote: Dear Sanjib, Its not working improting i need to import all Mail IDs from My Sent Inbox Folder, i need any macro for this thanks On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Just follow follow the link http://support.microsoft.com/kb/295664 On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young rohan.j...@gmail.com wrote: Dear Group, how can i get all mail IDs from my outlook to excel to make a list of all IDs and Co., please help me out Thanks Regds ROHAN -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Regards Ashish Koul http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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
Re: $$Excel-Macros$$ Look up errors from 2 sheets.
The lookup names have to be entered the same on both sheets, some need a space and some don't have a space. Look more closely at the ones that yield #N/A. On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan drdeva...@gmail.com wrote: Hi Experts, i am getting error in vlookups in finding the names from 2 sheets. i have used index, match formula, but still have some errors. Please look into this, might have lack of formulas in this. Please suggest what need to use in such cases. Thanks Regards, *Deba Ranjan P* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Look up errors from 2 sheets.
That is what the problem, i have like wise thousand datas which manually not possible to enter one by one, i want to look up by some eventual formulas. Thanks Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 3:17 PM, Norman Cliff May nor...@gmail.com wrote: The lookup names have to be entered the same on both sheets, some need a space and some don't have a space. Look more closely at the ones that yield #N/A. On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan drdeva...@gmail.com wrote: Hi Experts, i am getting error in vlookups in finding the names from 2 sheets. i have used index, match formula, but still have some errors. Please look into this, might have lack of formulas in this. Please suggest what need to use in such cases. Thanks Regards, *Deba Ranjan P* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Need Help
Hello, I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF Column I0, then Operation otherwise Commissioning. Please help. I am stuck now. Regards, Imran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Example_02.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need Help
On Tue, Jul 10, 2012 at 3:55 PM, Deba Ranjan drdeva...@gmail.com wrote: PFA, might it will help you. Thanks Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 3:35 PM, Imran khan ikha...@gmail.com wrote: Hello, I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF Column I0, then Operation otherwise Commissioning. Please help. I am stuck now. Regards, Imran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With Regards, *Vishal K. Angre* E-mail : visha...@gmail.com vishal.k.an...@gmail.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Example_02(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Need Help
Hello Khan, Please check the file attached , hope it helps. On Tuesday, July 10, 2012 1:05:17 PM UTC+3, Imran khan wrote: Hello, I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF Column I0, then Operation otherwise Commissioning. Please help. I am stuck now. Regards, Imran On Tuesday, July 10, 2012 1:05:17 PM UTC+3, Imran khan wrote: Hello, I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF Column I0, then Operation otherwise Commissioning. Please help. I am stuck now. Regards, Imran On Tuesday, July 10, 2012 1:05:17 PM UTC+3, Imran khan wrote: Hello, I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF Column I0, then Operation otherwise Commissioning. Please help. I am stuck now. Regards, Imran On Tuesday, July 10, 2012 1:05:17 PM UTC+3, Imran khan wrote: Hello, I need IF formula in attached sheet. IF Column C0, Then Pre-Ops otherwise Construction, IF Column F0, then Commissioning otherwise Pre-Ops IF Column I0, then Operation otherwise Commissioning. Please help. I am stuck now. Regards, Imran -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Example_02.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Look up errors from 2 sheets.
Hello , In case you have to files .xls and .xlsx you have to make formula with Insert Function ( ALT + I + F ). instead of write =vlookup or =lookup give it a try. On Tuesday, July 10, 2012 12:23:47 PM UTC+3, Bhaity wrote: Hi Experts, i am getting error in vlookups in finding the names from 2 sheets. i have used index, match formula, but still have some errors. Please look into this, might have lack of formulas in this. Please suggest what need to use in such cases. Thanks Regards, *Deba Ranjan P* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Look up errors from 2 sheets.
Thanks Ji,but could you please solve in the sheet. Thanks Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 4:08 PM, CoRe neculae.vale...@gmail.com wrote: Hello , In case you have to files .xls and .xlsx you have to make formula with Insert Function ( ALT + I + F ). instead of write =vlookup or =lookup give it a try. On Tuesday, July 10, 2012 12:23:47 PM UTC+3, Bhaity wrote: Hi Experts, i am getting error in vlookups in finding the names from 2 sheets. i have used index, match formula, but still have some errors. Please look into this, might have lack of formulas in this. Please suggest what need to use in such cases. Thanks Regards, *Deba Ranjan P* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ no of sheets in a workbook
Dear all, This is very useful information and I have been trying to use it at my work. Since, I am in beginner phase can you please teach me as to how to do it from the scratch? Thank you all, Sunita On Tue, Jul 10, 2012 at 12:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amit, Try it.. *Application.OnKey %{+}, short_key * Sub short_key() MsgBox Sheets.Count End Sub You can change combination % for Alt (^) for Ctrl (+) for Shift -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 10, 2012 at 11:11 AM, amitkmr amitjanku...@gmail.com wrote: Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ no of sheets in a workbook
Hi Sunita, Please find below link, hope it will you to explain How can use Hotkey In VBA http://www.excely.com/excel-vba/assign-hotkey-to-smartdel-macro.shtml http://www.mrexcel.com/archive/VBA/3401b.html On Tue, Jul 10, 2012 at 4:22 PM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, This is very useful information and I have been trying to use it at my work. Since, I am in beginner phase can you please teach me as to how to do it from the scratch? Thank you all, Sunita On Tue, Jul 10, 2012 at 12:02 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amit, Try it.. *Application.OnKey %{+}, short_key * Sub short_key() MsgBox Sheets.Count End Sub You can change combination % for Alt (^) for Ctrl (+) for Shift -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 10, 2012 at 11:11 AM, amitkmr amitjanku...@gmail.com wrote: Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ no of sheets in a workbook
Thank you Noorain. I hope can look at you if stuck in there. Thank you once again. Sunita On Tue, Jul 10, 2012 at 5:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sunita, Please find below link, hope it will you to explain How can use Hotkey In VBA http://www.excely.com/excel-vba/assign-hotkey-to-smartdel-macro.shtml http://www.mrexcel.com/archive/VBA/3401b.html On Tue, Jul 10, 2012 at 4:22 PM, सुनिता पौडेल tosune...@gmail.com wrote: Dear all, This is very useful information and I have been trying to use it at my work. Since, I am in beginner phase can you please teach me as to how to do it from the scratch? Thank you all, Sunita On Tue, Jul 10, 2012 at 12:02 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amit, Try it.. *Application.OnKey %{+}, short_key * Sub short_key() MsgBox Sheets.Count End Sub You can change combination % for Alt (^) for Ctrl (+) for Shift -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jul 10, 2012 at 11:11 AM, amitkmr amitjanku...@gmail.comwrote: Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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.
Re: $$Excel-Macros$$ Re: Look up errors from 2 sheets.
Hi Deba, Anil Solution is nice you can also use below formula without using Ctrl+shfit+Enter =LOOKUP(2,1/(SUBSTITUTE(SalarySheet!$A$2:$A$146, ,)=SUBSTITUTE($B2, ,)),SalarySheet!$D$2:$D$146) On Tue, Jul 10, 2012 at 4:56 PM, Anil Gawli gawlianil8...@gmail.com wrote: Dear devaran,deba,neculae Just see the attachment u'll get the idea . Thanks Regards,. Gawli Anil On Tue, Jul 10, 2012 at 4:09 PM, Deba Ranjan wrote: Thanks Ji,but could you please solve in the sheet. Thanks Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 4:08 PM, CoRe wrote: Hello , In case you have to files .xls and .xlsx you have to make formula with Insert Function ( ALT + I + F ). instead of write =vlookup or =lookup give it a try. On Tuesday, July 10, 2012 12:23:47 PM UTC+3, Bhaity wrote: Hi Experts, i am getting error in vlookups in finding the names from 2 sheets. i have used index, match formula, but still have some errors. Please look into this, might have lack of formulas in this. Please suggest what need to use in such cases. Thanks Regards, *Deba Ranjan P* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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
Re: $$Excel-Macros$$ no of sheets in a workbook
Sub listfiles() For i = 1 To Sheets.Count Cells(i, 1) = Sheets(i).Name Next End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: amitkmr Sent: Tuesday, July 10, 2012 12:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ no of sheets in a workbook Dear Sir, Do we have a shortcut to know the number and name of the sheets in a workbook and also list them in sequence. Amit Kumar -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Split tif page using EXCEL VBA
Hi All, I got the below coding from some other sites.. but while executing this macro, i got error messages and i can't solve this coding issue. Please help me to get resolve or any new coding to split tif images thru excel vba macro. * Option Explicit Dim ImageFile As Long Dim BitMapImage As Long Private Sub cmdFile_Click() cmdSplit.Enabled = False ' create a open dialog so that you can select ' the multipage tiff to split CommonDialog.InitDir = App.Path CommonDialog.DialogTitle = Select Multi Page TIFF CommonDialog.DefaultExt = *.TIF CommonDialog.Filter = TIF Files|*.TIF|TIFF Files|*.TIFF CommonDialog.ShowOpen If (Len(CommonDialog.Filename) 0) Then ' apply the selected image to the Kodak ' thumbnail control to display icons of the ' different pages imgThumb.Image = CommonDialog.Filename imgThumb.Refresh ' use the FreeImage DLL to open the multipage ' TIFF file, and use the GetPageCount function ' to determine if there are multiple pages to ' process ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _ CommonDialog.Filename, False, True) If (FreeImage_GetPageCount(ImageFile) 1) Then cmdSplit.Enabled = True End If ' update caption bar with filename + page count Caption = CommonDialog.Filename _ FreeImage_GetPageCount(ImageFile) page(s) ' close the multi-page TIFF file Call FreeImage_CloseMultiBitmap(ImageFile) End If End Sub Private Sub cmdSplit_Click() Dim pages As Integer Dim i As Integer ' use the FreeImage DLL to open the multipage ' TIFF file, and use the GetPageCount function ' to determine if there are multiple pages to process ImageFile = FreeImage_OpenMultiBitmap(FIF_TIFF, _ CommonDialog.Filename, False, True) pages = FreeImage_GetPageCount(ImageFile) i = 0 Do While i = (pages - 1) ' use the lock page function to copy that ' page into a new variable BitMapImage BitMapImage = FreeImage_LockPage(ImageFile, i) ' save that page out to a new filename Call FreeImage_Save(FIF_TIFF, BitMapImage, _ App.Path \page i + 1 .tif) ' unlock the page Call FreeImage_UnlockPage(ImageFile, i, False) i = i + 1 Loop ' close the multi-page TIFF file Call FreeImage_CloseMultiBitmap(ImageFile) ' feedback to user that process is complete MsgBox pages pages, split from _ CommonDialog.Filename, vbInformation, Complete End Sub * I will expect your views and suggestion to get solution for this coding. Please let me know if you have any clairifications. Thanks Regards, Ganesh -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Query - AutoNumber
NEI Not enough information Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Excel Vba Sent: Tuesday, July 10, 2012 8:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Query - AutoNumber
can u give a idea On Tue, Jul 10, 2012 at 7:52 PM, dguillett1 dguille...@gmail.com wrote: NEI Not enough information Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Excel Vba excelvba.lear...@gmail.com *Sent:* Tuesday, July 10, 2012 8:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Query - AutoNumber
Sorry, not enough info. WHERE do you have the numbers? how do you tell what the last number used was? are the numbers actual NUMBERS or are they ALPHAnumeric? (like: A123456) For instance, if the numbers are all in column A, AND THEY'RE NUMERIC then you can use: NextNo = Application.WorksheetFunction.Max(Sheets(Sheet1).Range(A:A)) + 1 of course, this assumes that they're in column A of a sheet called Sheet1, and they're actual numbers. without more info, this is the best I can do. 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: Excel Vba excelvba.lear...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, July 10, 2012 9:42:23 AM Subject: $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant.-- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Extracting a word from the cell.......
If you are saying you want the first word in a string then =LEFT(D10,FIND( ,D10)) or Sub fw() For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row Cells(i, c).Value = Left(Cells(i, d), InStr(1, Cells(i, d), )) Next i End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Tuesday, July 10, 2012 9:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting a word from the cell... Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment……… Regards, Muneer, CC…. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.comimage001.gif
Re: $$Excel-Macros$$ Query - AutoNumber
Thnaks Paul. - On Tue, Jul 10, 2012 at 8:00 PM, Paul Schreiner schreiner_p...@att.netwrote: Sorry, not enough info. WHERE do you have the numbers? how do you tell what the last number used was? are the numbers actual NUMBERS or are they ALPHAnumeric? (like: A123456) For instance, if the numbers are all in column A, AND THEY'RE NUMERIC then you can use: NextNo = Application.WorksheetFunction.Max(Sheets(Sheet1).Range(A:A)) + 1 of course, this assumes that they're in column A of a sheet called Sheet1, and they're actual numbers. without more info, this is the best I can do. *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:* Excel Vba excelvba.lear...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, July 10, 2012 9:42:23 AM *Subject:* $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Re: Extracting a word from the cell.......
Hi Muneer, Please see the attachment. regards Prince dubey. On Tuesday, July 10, 2012 7:55:34 PM UTC+5:30, Mohammed Muneer wrote: Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment……… Regards, Muneer, CC…. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Exerciseformula.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: please help,,,
Hi Ann, Can you please explain bit more about your issue.As we are not able to understand your Issue. Do you want to copy data from active cell or anything else ? regards Prince dubey. On Tuesday, July 10, 2012 3:21:50 PM UTC+5:30, an wrote: Dear experts, please help to do view code in excel sheet, (prnt scrn below attached), Regards, Ann [image: Inline image 1] -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ Extracting a word from the cell.......
Which word you want to extract? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: 10 July 2012 7:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting a word from the cell... Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment... Regards, Muneer, CC.. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.comimage001.gif
$$Excel-Macros$$ switch on anf off calculation
Hi All, can you help me on this. I have quite large excel file, because there is a lot of calculation, I'd like to switch off excel calculation and when I'll be closing file schitch on calculation. I mean by macro (manually I know how to do this :) ) thanks a lot Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ switch on anf off calculation
Use this line in your macro :- Application.Calculation=xlCalculationManual Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey Co. From: pawel lupinski lupins...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, 11 July 2012 7:03 AM Subject: $$Excel-Macros$$ switch on anf off calculation Hi All, can you help me on this. I have quite large excel file, because there is a lot of calculation, I'd like to switch off excel calculation and when I'll be closing file schitch on calculation. I mean by macro (manually I know how to do this :) ) thanks a lot Pawel -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
RE: $$Excel-Macros$$ Extracting a word from the cell.......
Dear Don, Superb Innovative. Keep it up! Both code and formula good. Experience is the mother of Knowledge Whenever I receive a help from u people, in a fraction of seconds I feel myself why I can't do this magic by myself. But I keep trying to do some until I get an idea. But I never felt unhappy on my failure. Pray for me, I will be one among u who r active hands for these group members. Lots of thanks... Regards, Muneer, CC If you are saying you want the first word in a string then =LEFT(D10,FIND( ,D10)) or Sub fw() For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row Cells(i, c).Value = Left(Cells(i, d), InStr(1, Cells(i, d), )) Next i End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mohammed Muneer mailto:mmun...@ccc.com.qa Sent: Tuesday, July 10, 2012 9:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting a word from the cell... Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment. Regards, Muneer, CC -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Extracting a word from the cell.......
Hi Shai, For First Word:- =IFERROR(LEFT(G2,FIND( ,G2,1)),G2) For Second:- =IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND( ,G2,1)),FIND( ,RIGHT(G2,LEN(G2)-FIND( ,G2,1,) For third:- =IFERROR(IF(LEN(C2F2)+2=LEN(G2),””,MID(G2,LEN(C2)+7,LEN(G2)-LEN(C2F2)-7)),) For Forth:- =IFERROR(RIGHT(G2,LEN(G2)-FIND(#,SUBSTITUTE(G2, ,#,LEN(G2)-LEN(SUBSTITUTE(G2, ,),G2) Thanks Regards, *Deba Ranjan P* On Wed, Jul 11, 2012 at 10:02 AM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: This is really great ! Suppose I want extract 2nd or 3rd or 4th word, then ? Regards On Wed, Jul 11, 2012 at 9:39 AM, Mohammed Muneer mmun...@ccc.com.qawrote: Dear Don, Superb Innovative. Keep it up! Both code and formula good. ** ** ** ** *“Experience is the mother of Knowledge”* * * Whenever I receive a help from u people, in a fraction of seconds I feel myself why I can’t do this magic by myself. But I keep trying to do some until I get an idea. ** ** But I never felt unhappy on my failure. ** ** Pray for me, I will be one among u who r active hands for these group members. ** ** Lots of thanks……. ** ** ** ** Regards, Muneer, CC…. ** ** If you are saying you want the first word in a string then =LEFT(D10,FIND( ,D10)) or Sub fw() For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row Cells(i, c).Value = Left(Cells(i, d), InStr(1, Cells(i, d), ))** ** Next i End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Mohammed Muneer mmun...@ccc.com.qa *Sent:* Tuesday, July 10, 2012 9:25 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Extracting a word from the cell... Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment……… Regards, Muneer, CC…. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members
RE: $$Excel-Macros$$ Extracting a word from the cell.......
Wow! Superb here r the efforts. Regards, Muneer, CC Muneer Ji, PFA. For First Word:- =IFERROR(LEFT(G2,FIND( ,G2,1)),G2) For Second:- =IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND( ,G2,1)),FIND( ,RIGHT(G2,LEN(G2)-FIND( ,G2,1,) For third:- =IFERROR(IF(LEN(C2F2)+2=LEN(G2),,MID(G2,LEN(C2)+7,LEN(G2)-LEN(C2F2) -7)),) For Forth:- =IFERROR(RIGHT(G2,LEN(G2)-FIND(#,SUBSTITUTE(G2, ,#,LEN(G2)-LEN(SUBSTITUTE(G2, ,),G2) Thanks Regards, Deba Ranjan P On Wed, Jul 11, 2012 at 10:21 AM, Deba Ranjan drdeva...@gmail.com wrote: Hi Shai, For First Word:- =IFERROR(LEFT(G2,FIND( ,G2,1)),G2) For Second:- =IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND( ,G2,1)),FIND( ,RIGHT(G2,LEN(G2)-FIND( ,G2,1,) For third:- =IFERROR(IF(LEN(C2F2)+2=LEN(G2),,MID(G2,LEN(C2)+7,LEN(G2)-LEN(C2F2) -7)),) For Forth:- =IFERROR(RIGHT(G2,LEN(G2)-FIND(#,SUBSTITUTE(G2, ,#,LEN(G2)-LEN(SUBSTITUTE(G2, ,),G2) Thanks Regards, Deba Ranjan P On Wed, Jul 11, 2012 at 10:02 AM, Abdulgani Shaikh itpabdulg...@gmail.com wrote: This is really great ! Suppose I want extract 2nd or 3rd or 4th word, then ? Regards On Wed, Jul 11, 2012 at 9:39 AM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Don, Superb Innovative. Keep it up! Both code and formula good. Experience is the mother of Knowledge Whenever I receive a help from u people, in a fraction of seconds I feel myself why I can't do this magic by myself. But I keep trying to do some until I get an idea. But I never felt unhappy on my failure. Pray for me, I will be one among u who r active hands for these group members. Lots of thanks... Regards, Muneer, CC If you are saying you want the first word in a string then =LEFT(D10,FIND( ,D10)) or Sub fw() For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row Cells(i, c).Value = Left(Cells(i, d), InStr(1, Cells(i, d), )) Next i End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mohammed Muneer mailto:mmun...@ccc.com.qa Sent: Tuesday, July 10, 2012 9:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting a word from the cell... Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment. Regards, Muneer, CC -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@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