Re: $$Excel-Macros$$ How to delete alternate sheets faster
*Dear Noorain* * * *Pl inform how to and where to use this code..* *Thank you.* * * *Pravin. * On Thu, Nov 1, 2012 at 11:04 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Friends,* * * *Greetings !* * * *I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end.* * * *Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them.* * * *Thank you,* * * *Regards* *Pravin Gunjal.* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ 6 - 11 automatically changing to date formate it should display as it is
Dear Gurus, I have a file which has the values like 6 - 11 7 - 20 2 - 27 which is automatically changing to date format but it should display the same 6 - 11 7 - 20 2 - 27 Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ How to delete alternate sheets faster
Dear Pravin, Please press Alt+F11 and goto Insert-module and paste code and press F5 to execute macro. Hope it will useful for you. On Thu, Nov 1, 2012 at 11:40 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Noorain* * * *Pl inform how to and where to use this code..* *Thank you.* * * *Pravin. * On Thu, Nov 1, 2012 at 11:04 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Friends,* * * *Greetings !* * * *I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end.* * * *Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them.* * * *Thank you,* * * *Regards* *Pravin Gunjal.* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at
Re: $$Excel-Macros$$ 6 - 11 automatically changing to date formate it should display as it is
Dear Sundar, Please convert cell as Text Select required cell and press ctrl+1 and change format of cell as text. On Thu, Nov 1, 2012 at 11:52 AM, Sundarvelan N nsund...@gmail.com wrote: Dear Gurus, I have a file which has the values like 6 - 11 7 - 20 2 - 27 which is automatically changing to date format but it should display the same 6 - 11 7 - 20 2 - 27 Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to protect
*Hello,* *Can somebody help me out on this issue * *Thanks in advance.* * * *Regards* *Pravin Gunjal. * -- Forwarded message -- From: Pravin Gunjal isk1...@gmail.com Date: Tue, Oct 30, 2012 at 6:58 PM Subject: VBA enabled sheet doesn't allow to protect To: excel-macros@googlegroups.com *Dear Rajan* * * *Actually I wanted to work in a sheet which may be Protected OR UnProtected. * * * *When I tried this macro in a file it is allowing me to work with protection but whenever I would like to edit OR enter the data in that particular sheet it's immediately getting protected automatically.* * * *Pravin Gunjal.* * * -- Forwarded message -- From: Rajan_Verma rajanverma1...@gmail.com Date: Tue, Oct 30, 2012 at 6:55 PM Subject: RE: $$Excel-Macros$$ Re: VBA enabled sheet doesn't allow to protect To: excel-macros@googlegroups.com, Pravin Gunjal isk1...@gmail.com *So you want button for protect or Unprotect Sheet?* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* Pravin Gunjal [mailto:isk1...@gmail.com] *Sent:* 30 October 2012 6:52 *To:* excel-macros@googlegroups.com; Rajan Verma - Gurgaon Excel *Subject:* Fwd: $$Excel-Macros$$ Re: VBA enabled sheet doesn't allow to protect ** ** *Thanks Rajan.* ** ** *I can be able to work now in the protected sheet with macro/conditional formatting, but whenever I would like to edit / enter the data in this sheet, I use to unprotect the sheet, and if I enter again or move to any other field the sheet is automatically getting protected.* ** ** *It should be work manually (Protect/ UnProtect) and not automatically. Please look in to this and inform. Thank you!* ** ** *Regards* *Pravin Gunjal* ** ** -- Forwarded message -- From: *Rajan_Verma* rajanverma1...@gmail.com Date: Mon, Oct 29, 2012 at 10:05 AM Subject: RE: $$Excel-Macros$$ Re: VBA enabled sheet doesn't allow to protect To: excel-macros@googlegroups.com * * *Try this* *Private Sub Worksheet_SelectionChange(ByVal Target As Range)* ** *With ThisWorkbook.Worksheets(Field Emails)* *.Unprotect* *[selRow] = Target.Row* *[selCol] = Target.Column* *.Protect* *End With* ** *End Sub* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *On Behalf Of *Prince *Sent:* 27 October 2012 3:53 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Re: VBA enabled sheet doesn't allow to protect** ** Hi Pravin, Plz See the Attachment regards Prince On Saturday, October 20, 2012 11:58:34 AM UTC+5:30, Pravin Gunjal wrote: *Dear Friends,* *I have an Macro / VBA enabled file with me. If I protect the sheet which has a VBA code, then macro doesn't work and displays the following error. Kindly get the solution on it topic. Thank you.* *[image: Inline image 1]* *Regards* *Pravin Gunjal.* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ How to delete alternate sheets faster
Dear Noorain Sir, Can you ammend your code that when we run macro, a message box appear and ask for select the sheets which you want to delete and we will select the multiple sheet which we want to delete. Aamir Shahzad On Thu, Nov 1, 2012 at 11:34 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Noorain* *I have attached my file for your reference.* *Pl look in to this and inform.* *Thanks,* *Pravin.* On Thu, Nov 1, 2012 at 11:53 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Pravin, Please press Alt+F11 and goto Insert-module and paste code and press F5 to execute macro. Hope it will useful for you. On Thu, Nov 1, 2012 at 11:40 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Noorain* * * *Pl inform how to and where to use this code..* *Thank you.* * * *Pravin. * On Thu, Nov 1, 2012 at 11:04 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.comwrote: *Dear Friends,* * * *Greetings !* * * *I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end. * * * *Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them. * * * *Thank you,* * * *Regards* *Pravin Gunjal.* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing
Re: $$Excel-Macros$$ need solutions
Hello Satendra Thanks for the help. One more thing I want to know If I want to do this from other file and process how can I put this formula in the sheet. Once again thanks On Wednesday, October 31, 2012 1:29:03 PM UTC+5:30, Satendra kumar wrote: Hi, Find Another solution i think this is right solution.. as per ur requirement.. thankx satendra On Wed, Oct 31, 2012 at 1:23 PM, Amresh Maurya amreshk...@gmail.comjavascript: wrote: On Wed, Oct 31, 2012 at 1:22 PM, Satendra kumar satendr...@gmail.com javascript: wrote: Hi, Find Attachment. On Wed, Oct 31, 2012 at 1:20 PM, Rajesh Agarwal raje...@gmail.comjavascript: wrote: PFA -- Rajesh Kumar Agarwal 9811063001 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards Satendra Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards Satendra Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Fwd: $$Excel-Macros$$ How to delete alternate sheets faster
*It would be better... * -- Forwarded message -- From: Aamir Shahzad aamirshahza...@gmail.com Date: Thu, Nov 1, 2012 at 12:13 PM Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster To: excel-macros@googlegroups.com Dear Noorain Sir, Can you ammend your code that when we run macro, a message box appear and ask for select the sheets which you want to delete and we will select the multiple sheet which we want to delete. Aamir Shahzad On Thu, Nov 1, 2012 at 11:34 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Noorain* *I have attached my file for your reference.* *Pl look in to this and inform.* *Thanks,* *Pravin.* On Thu, Nov 1, 2012 at 11:53 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Pravin, Please press Alt+F11 and goto Insert-module and paste code and press F5 to execute macro. Hope it will useful for you. On Thu, Nov 1, 2012 at 11:40 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Noorain* * * *Pl inform how to and where to use this code..* *Thank you.* * * *Pravin. * On Thu, Nov 1, 2012 at 11:04 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.comwrote: *Dear Friends,* * * *Greetings !* * * *I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end. * * * *Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them. * * * *Thank you,* * * *Regards* *Pravin Gunjal.* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ Macro for Find
Dear Vijay File is not working Regards Shrinivas On Tue, Oct 30, 2012 at 6:31 PM, Vijay Kr. Aggarwal vjaggarwal2...@gmail.com wrote: Hi Shrini, First sheet:- Raw Data Second Sheet :- Criteria is given in this sheet. third sheet :- Final output would be pasted here by using criteria from second sheet. regards, Vijay On 10/30/12, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear Rajan and ANil Sample file is already attached . Dear Vijay Can u explain me the file u send Regards Shrinivas On Mon, Oct 29, 2012 at 7:27 PM, Vijay Kr. Aggarwal vjaggarwal2...@gmail.com wrote: Hi Shrinivas, Please check attached file. I hope this will answer your query. regards, Vijay On 10/27/12, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear all I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example .-: user want to find details of H.then macro should ask the name and only that details will be paste in sheet 2 Other search may be user want details of all the people whose age is in between 23 to 27 -- Shrini -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en . -- Regards, Vijay Kumar Aggarwal -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Shrini -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ How to delete alternate sheets faster
That's not going to work out well. Let's say you have 11 sheets the Sheets() array looks like: Sheets(1).Name = One Sheets(2).Name = Two Sheets(3).Name = Three Sheets(4).Name = Four Sheets(5).Name = Five Sheets(6).Name = Six Sheets(7).Name = Seven Sheets(8).Name = Eight Sheets(9).Name = Nine Sheets(10).Name = Ten Sheets(11).Name = Eleven Your INTENT is to delete Sheets Two, Four, Six, Eight, Ten If you use: For I = 2 to Sheets.Count step 2 The first loop, Sheet Two is deleted. The Sheets Array then looks like: Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Five Sheets(5).Name = Six Sheets(6).Name = Seven Sheets(7).Name = Eight Sheets(8).Name = Nine Sheets(9).Name = Ten Sheets(10).Name = Eleven In the next Loop, Sheets(4) is deleted, but that is now a sheet named Five !!! Also, by the time the loop gets to delete sheets(10), Sheets.Count will only be 7, so an error will occur. Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Six Sheets(5).Name = Seven Sheets(6).Name = Nine Sheets(7).Name = Eleven You should start at the last sheet and work backward: If you KNOW that the number of sheets is 43, and will always be 43, then you can use: For I = 42 to 2 step -2 If you don't know the total number of sheets, you can use: If (Sheets.Count Mod 2 = 0) Then ShtCnt = Sheets.Count Else ShtCnt = Sheets.Count - 1 End If for I = shtcnt to 2 step -2 (the code would be best placed in a Standard module, or the Sheet1 module) 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: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, November 1, 2012 1:35:04 AM Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.com wrote: Dear Friends, Greetings ! I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end. Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them. Thank you, Regards Pravin Gunjal. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http://noorainansari.com http://excelvbaclinic.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups
Re: $$Excel-Macros$$ excel macros for pasting to selected range
I tried it and it worked fine. However, I didn't spend the time to create a bunch of drop-down menus. I just used some data I already had. Maybe the problem is with copying the selected values of the drop-downs. perhaps if you posted your file? (or an edited version) Otherwise, we could spend a whole bunch of time trying to fix a problem that has nothing to do with what you're experiencing. 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: key log target...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, October 31, 2012 5:13:54 PM Subject: Re: $$Excel-Macros$$ excel macros for pasting to selected range I tried it and it didn't work. I select two whole rows and when I run the macros nothing happens On Wednesday, October 31, 2012 12:26:09 PM UTC-7, Sam Mathai Chacko wrote: Is this what you wanted?? Sub CopyToRows() Dim strRange As String strRange = Selection.EntireRow.Address(0, 0) Range(strRange).Value = Range(2:2).Value End Sub Regards, Sam Mathai Chacko On Thu, Nov 1, 2012 at 12:50 AM, key log targ...@gmail.com wrote: Hi all, This is a very easy macro but since I just started learning about VBA I'm having a hard time making something that works. What I want to do is have a macros button that will paste a specific row to a selected field. So, I want the user to select whatever rows they want, say rows 99-101 and then click the macro button which will paste whatever is on ROW 2 to the selected rows, which is a bunch of drop down menus. Any help is greatly appreciated.-- Join official facebook page of this forum @ https://www.facebook.com/ discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@ googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Sam Mathai Chacko -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing
Re: $$Excel-Macros$$ How to delete alternate sheets faster
Dear Pravin, Use the solution which suit your need and meets your requirement. But my solution will be something like this : By holding Ctrl Key and by using Mouse click select the sheets you wish to delete. Once the selection of sheets is done --- right click and choose delete --- this will delete all the sheets that you choose = This is also possible if you doesnt wish to use the VBA code. Let me know if you failed to understand. Thanks Ahmed Bawazir by Clicking by mouse select all the sheets that you wish to delete On Thu, Nov 1, 2012 at 2:46 PM, Paul Schreiner schreiner_p...@att.netwrote: That's not going to work out well. Let's say you have 11 sheets the Sheets() array looks like: Sheets(1).Name = One Sheets(2).Name = Two Sheets(3).Name = Three Sheets(4).Name = Four Sheets(5).Name = Five Sheets(6).Name = Six Sheets(7).Name = Seven Sheets(8).Name = Eight Sheets(9).Name = Nine Sheets(10).Name = Ten Sheets(11).Name = Eleven Your INTENT is to delete Sheets Two, Four, Six, Eight, Ten If you use: For I = 2 to Sheets.Count step 2 The first loop, Sheet Two is deleted. The Sheets Array then looks like: Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Five Sheets(5).Name = Six Sheets(6).Name = Seven Sheets(7).Name = Eight Sheets(8).Name = Nine Sheets(9).Name = Ten Sheets(10).Name = Eleven In the next Loop, Sheets(4) is deleted, but that is now a sheet named Five !!! Also, by the time the loop gets to delete sheets(10), Sheets.Count will only be 7, so an error will occur. Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Six Sheets(5).Name = Seven Sheets(6).Name = Nine Sheets(7).Name = Eleven You should start at the last sheet and work backward: If you KNOW that the number of sheets is 43, and will always be 43, then you can use: For I = 42 to 2 step -2 If you don't know the total number of sheets, you can use: If (Sheets.Count Mod 2 = 0) Then ShtCnt = Sheets.Count Else ShtCnt = Sheets.Count - 1 End If for I = shtcnt to 2 step -2 (the code would be best placed in a Standard module, or the Sheet1 module) *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:* NOORAIN ANSARI noorain.ans...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, November 1, 2012 1:35:04 AM *Subject:* Re: $$Excel-Macros$$ How to delete alternate sheets faster Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Friends,* * * *Greetings !* * * *I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end.* * * *Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them.* * * *Thank you,* * * *Regards* *Pravin Gunjal.* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @
Re: $$Excel-Macros$$ How to delete alternate sheets faster
Another way would be to create an array of sheet names and the delete it accordingly. So even if you go with a positive Step, it would still work. Based on the suggestions above, you can come up with the loop... however, in the end, the array should be passed like this ThisWorkbook.Sheets(Array(Sheet1, Sheet3, Sheet5)).Delete (example) Regards Sam On Thu, Nov 1, 2012 at 5:46 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Pravin, Use the solution which suit your need and meets your requirement. But my solution will be something like this : By holding Ctrl Key and by using Mouse click select the sheets you wish to delete. Once the selection of sheets is done --- right click and choose delete --- this will delete all the sheets that you choose = This is also possible if you doesnt wish to use the VBA code. Let me know if you failed to understand. Thanks Ahmed Bawazir by Clicking by mouse select all the sheets that you wish to delete On Thu, Nov 1, 2012 at 2:46 PM, Paul Schreiner schreiner_p...@att.netwrote: That's not going to work out well. Let's say you have 11 sheets the Sheets() array looks like: Sheets(1).Name = One Sheets(2).Name = Two Sheets(3).Name = Three Sheets(4).Name = Four Sheets(5).Name = Five Sheets(6).Name = Six Sheets(7).Name = Seven Sheets(8).Name = Eight Sheets(9).Name = Nine Sheets(10).Name = Ten Sheets(11).Name = Eleven Your INTENT is to delete Sheets Two, Four, Six, Eight, Ten If you use: For I = 2 to Sheets.Count step 2 The first loop, Sheet Two is deleted. The Sheets Array then looks like: Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Five Sheets(5).Name = Six Sheets(6).Name = Seven Sheets(7).Name = Eight Sheets(8).Name = Nine Sheets(9).Name = Ten Sheets(10).Name = Eleven In the next Loop, Sheets(4) is deleted, but that is now a sheet named Five !!! Also, by the time the loop gets to delete sheets(10), Sheets.Count will only be 7, so an error will occur. Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Six Sheets(5).Name = Seven Sheets(6).Name = Nine Sheets(7).Name = Eleven You should start at the last sheet and work backward: If you KNOW that the number of sheets is 43, and will always be 43, then you can use: For I = 42 to 2 step -2 If you don't know the total number of sheets, you can use: If (Sheets.Count Mod 2 = 0) Then ShtCnt = Sheets.Count Else ShtCnt = Sheets.Count - 1 End If for I = shtcnt to 2 step -2 (the code would be best placed in a Standard module, or the Sheet1 module) *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:* NOORAIN ANSARI noorain.ans...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, November 1, 2012 1:35:04 AM *Subject:* Re: $$Excel-Macros$$ How to delete alternate sheets faster Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Friends,* * * *Greetings !* * * *I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end.* * * *Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them.* * * *Thank you,* * * *Regards* *Pravin Gunjal.* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to
Re: $$Excel-Macros$$ How to delete alternate sheets faster
Yeah, Sam.. I thought about that. But he said he had 43 sheets! (OK, he's only deleting 21) That's kind of a cumbersome array to manage, although I'm sure it could be done. 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: Sam Mathai Chacko samde...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Cc: Pravin Gunjal isk1...@gmail.com Sent: Thu, November 1, 2012 8:24:16 AM Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster Another way would be to create an array of sheet names and the delete it accordingly. So even if you go with a positive Step, it would still work. Based on the suggestions above, you can come up with the loop... however, in the end, the array should be passed like this ThisWorkbook.Sheets(Array(Sheet1, Sheet3, Sheet5)).Delete (example) Regards Sam On Thu, Nov 1, 2012 at 5:46 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Pravin, Use the solution which suit your need and meets your requirement. But my solution will be something like this : By holding Ctrl Key and by using Mouse click select the sheets you wish to delete. Once the selection of sheets is done --- right click and choose delete --- this will delete all the sheets that you choose = This is also possible if you doesnt wish to use the VBA code. Let me know if you failed to understand. Thanks Ahmed Bawazir by Clicking by mouse select all the sheets that you wish to delete On Thu, Nov 1, 2012 at 2:46 PM, Paul Schreiner schreiner_p...@att.net wrote: That's not going to work out well. Let's say you have 11 sheets the Sheets() array looks like: Sheets(1).Name = One Sheets(2).Name = Two Sheets(3).Name = Three Sheets(4).Name = Four Sheets(5).Name = Five Sheets(6).Name = Six Sheets(7).Name = Seven Sheets(8).Name = Eight Sheets(9).Name = Nine Sheets(10).Name = Ten Sheets(11).Name = Eleven Your INTENT is to delete Sheets Two, Four, Six, Eight, Ten If you use: For I = 2 to Sheets.Count step 2 The first loop, Sheet Two is deleted. The Sheets Array then looks like: Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Five Sheets(5).Name = Six Sheets(6).Name = Seven Sheets(7).Name = Eight Sheets(8).Name = Nine Sheets(9).Name = Ten Sheets(10).Name = Eleven In the next Loop, Sheets(4) is deleted, but that is now a sheet named Five !!! Also, by the time the loop gets to delete sheets(10), Sheets.Count will only be 7, so an error will occur. Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Six Sheets(5).Name = Seven Sheets(6).Name = Nine Sheets(7).Name = Eleven You should start at the last sheet and work backward: If you KNOW that the number of sheets is 43, and will always be 43, then you can use: For I = 42 to 2 step -2 If you don't know the total number of sheets, you can use: If (Sheets.Count Mod 2 = 0) Then ShtCnt = Sheets.Count Else ShtCnt = Sheets.Count - 1 End If for I = shtcnt to 2 step -2 (the code would be best placed in a Standard module, or the Sheet1 module) 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: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, November 1, 2012 1:35:04 AM Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.com wrote: Dear Friends, Greetings ! I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end. Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them. Thank you, Regards Pravin Gunjal. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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.
Fwd: $$Excel-Macros$$ How to delete alternate sheets faster
*Hi Paul,* * * *Could you please inform me the full code, so that I can apply it in the attached file for test purpose and later on in my original file for use.* * * *And thanks to all for their solutions too.* * * *Regards* *Pravin Gunjal* -- Forwarded message -- From: Paul Schreiner schreiner_p...@att.net Date: Thu, Nov 1, 2012 at 5:16 PM Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster To: excel-macros@googlegroups.com That's not going to work out well. Let's say you have 11 sheets the Sheets() array looks like: Sheets(1).Name = One Sheets(2).Name = Two Sheets(3).Name = Three Sheets(4).Name = Four Sheets(5).Name = Five Sheets(6).Name = Six Sheets(7).Name = Seven Sheets(8).Name = Eight Sheets(9).Name = Nine Sheets(10).Name = Ten Sheets(11).Name = Eleven Your INTENT is to delete Sheets Two, Four, Six, Eight, Ten If you use: For I = 2 to Sheets.Count step 2 The first loop, Sheet Two is deleted. The Sheets Array then looks like: Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Five Sheets(5).Name = Six Sheets(6).Name = Seven Sheets(7).Name = Eight Sheets(8).Name = Nine Sheets(9).Name = Ten Sheets(10).Name = Eleven In the next Loop, Sheets(4) is deleted, but that is now a sheet named Five !!! Also, by the time the loop gets to delete sheets(10), Sheets.Count will only be 7, so an error will occur. Sheets(1).Name = One Sheets(2).Name = Three Sheets(3).Name = Four Sheets(4).Name = Six Sheets(5).Name = Seven Sheets(6).Name = Nine Sheets(7).Name = Eleven You should start at the last sheet and work backward: If you KNOW that the number of sheets is 43, and will always be 43, then you can use: For I = 42 to 2 step -2 If you don't know the total number of sheets, you can use: If (Sheets.Count Mod 2 = 0) Then ShtCnt = Sheets.Count Else ShtCnt = Sheets.Count - 1 End If for I = shtcnt to 2 step -2 (the code would be best placed in a Standard module, or the Sheet1 module) *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:* NOORAIN ANSARI noorain.ans...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, November 1, 2012 1:35:04 AM *Subject:* Re: $$Excel-Macros$$ How to delete alternate sheets faster Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal isk1...@gmail.com wrote: *Dear Friends,* * * *Greetings !* * * *I am having an excel file (office 2007) containing 43 sheets in it and would like to delete alternative sheets like 2-4-6 etc. up to the end.* * * *Is it possible to select all those sheets at a time and delete the same. As currently I am selecting one by one and deleting all of them.* * * *Thank you,* * * *Regards* *Pravin Gunjal.* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
$$Excel-Macros$$ sharepoint to acces
Hi- Our team is currently using an Infopath form in SharePoint but looking to move to an Access database. We would like to be able to use as a resource request and have questions posted to the Access database. Does anyone know if this is something that can be done in Microsoft Access- and if so how can I get started in creating? -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Pls help
Hi, try this, Ctrl+F, put value in Find What, Find All, Ctrl+A and then Esc regds On Thu, Nov 1, 2012 at 8:30 PM, karthikeyan sankaran karthikeyansankar...@gmail.com wrote: Hi, How to select particular cell value within one click.I need to select value 2 only. without using macro , filter and ctrl+cell. example:- 1 2 3 1 2 1 2 Thanks, karthik -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: QC results update tool
Hi Friends, Can anyone please help me with the code which is used to establish the connectivity between HP ALM and macros and also to update some fields in ALM. Regards Nevin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Security Manager :: Boston, MA
Hi Partners, DIRECT CLIENT - In person interview is needed after TELEPHONIC ROUND. Location: Boston, MA Duration: 6+ months Rate: open/hr C2C Skills Needed: . Experience should include security policy development, security education, network penetration testing, application vulnerability assessments, risk analysis and compliance testing. CISSP or CISAcertifications required. . Ability to analyze and determine the applicability of data, to draw conclusions and make appropriate recommendations; . Ability to communicate effectively in oral expression. . Ability to gather information by examining records and documents and by questioning individuals. . Ability to assemble items of information in accordance with established procedures. . Ability to determine proper format and procedure for assembling items of information. . Ability to maintain accurate records; . Ability to follow written and oral instructions. . Ability to prepare and use charts, graphs and tables; . Ability to prepare general reports. . Ability to write concisely, to express thoughts clearly and to develop ideas in logical sequence. . Ability to supervise, including planning and assigning work according to the nature of the job to be accomplished, the capabilities of subordinates and available resources; controlling work through periodic reviews and/or evaluations; determining subordinates' training needs and providing or arranging for such training; motivating subordinates to work effectively; determining the need for disciplinary action and either recommending or initiating disciplinary action. . 3 years experience in working in a PCI-DSS credit card environment. . Knowledge of secure coding techniques, Active Directory, patching using SCCM etc. . Additional IT experience as a programmer, system administrator or network engineer preferred . McAfee EPO . Rapid 7 . Websense . Knowledge of the principles, practices and techniques of supervision. . Knowledge of the laws, rules, regulations, policies, procedures, specifications, standards and guidelines governing assigned unit activities. MINIMUM REQUIRMENTS . BA or BS in Computer Science, Management Information Systems, or related field. Advanced degree desirable. . Five+ years of progressive experience in computing and information security, including experience with Internet technology and security issues. LICENSE AND/OR CERTIFICATION REQUIRMENTS . CISSP or CISA certification . Based on assignment, possession of a current and valid Class 3 Motor Vehicle Operator's License may be required. Thanks, Ankush Chaudhary Software People Inc. blocked::http://www.softwarepeople.us/ www.softwarepeople.us ankush.chaudh...@softwarepeople.us Ph: 631- 739-8494 Fax: 631-574-3122 Certifications: SBA 8a/SDB,NJ MWBE, NY MWBE, VA SWaM, DE OMWBE -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Senior Project Manager :: Boston, MA
Hi Partners, DIRECT CLIENT - In person interview is needed. Location: Boston, MA Duration: 9+ months Rate: Open C2C/W-2 (37.5 hrs/week) Skills Needed: . Minimum 3 years of project management experience in a technology environment . Proven track record of delivering large-scale projects to diverse stakeholders . Excellent communication, organization, interpersonal and writing skills . Demonstrated ability to work independently and take initiative . Proven track record of leading cross-functional teams on large scale projects . Proficiency with MS Project, or comparable project management software . Experience implementing system using standard data exchange protocols . Experience managing data integration projects PMO . Experience managing and implementing business intelligence projects . Experience working with web based and database technologies . Attentive to detail . Ability to work in a dynamic and fast-paced environment . Strong time management, communicative, and interpersonal skills . Technical / software development background . Experience delivering a project to create an integrated role-driven web portal using third-party portal software with features delivered through portlets. . Experience managing web services implementations and delivery of web-based services . Experience managing projects delivered in an educational environment, particularly PK-20 . Experience managing state government projects . Experience managing projects using unified process (RUP) and SDLC . Understanding of SOA / Service Oriented Architecture. . Understanding of SSO / Single Sign-on technology. . Understanding of how Information Architecture and User Centered Design need to be applied in a project through both requirements elicitation and development. . Understanding of web presentation development (e.g. HTML, CSS, Javascript, JSP). . PMP certification Thanks, Ankush Chaudhary Software People Inc. blocked::http://www.softwarepeople.us/ www.softwarepeople.us ankush.chaudh...@softwarepeople.us Ph: 631- 739-8494 Fax: 631-574-3122 Certifications: SBA 8a/SDB,NJ MWBE, NY MWBE, VA SWaM, DE OMWBE -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
$$Excel-Macros$$ Re: QC results update tool
HI Rajan/Friends, Thanks for your intrest in helping me. Objective of the tool is to update all the test case results in QC from an excel file through macros which inturn will avoid manual work. We have around 1200 TC's for every execution and once we develop it as tool it will reduce a lot of manual work which we are currently doing. Iam very new to using macros and coding.Iam finding very difficult to understand how it is working. Once again thank you. Regards Nevin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Security Manager :: Boston, MA
Moderator plz ban all this.. On Fri, Nov 2, 2012 at 9:52 AM, Satendra kumar satendrakuma...@gmail.comwrote: Yes Kuldeep you are right... On Fri, Nov 2, 2012 at 9:50 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Ankush, It's not a job posting portal, So don't post any job mail. Keep posting only excel Vba queries. Regards, Kuldeep Singh On Fri, Nov 2, 2012 at 12:52 AM, Ankush Chaudhary ankush.chaudh...@softwarepeople.us wrote: ** ** ** Hi Partners, * * * * *DIRECT CLIENT - In person interview is needed** **after TELEPHONIC ROUND.*** * * *Location: Boston, MA* *Duration: 6+ months* *Rate: open/hr C2C* * * *Skills Needed:* • Experience should include security policy development, security education, network penetration testing, application vulnerability assessments, risk analysis and compliance testing. CISSP or CISAcertifications required. • Ability to analyze and determine the applicability of data, to draw conclusions and make appropriate recommendations; • Ability to communicate effectively in oral expression. • Ability to gather information by examining records and documents and by questioning individuals. • Ability to assemble items of information in accordance with established procedures. • Ability to determine proper format and procedure for assembling items of information. • Ability to maintain accurate records; • Ability to follow written and oral instructions. • Ability to prepare and use charts, graphs and tables; • Ability to prepare general reports. • Ability to write concisely, to express thoughts clearly and to develop ideas in logical sequence. • Ability to supervise, including planning and assigning work according to the nature of the job to be accomplished, the capabilities of subordinates and available resources; controlling work through periodic reviews and/or evaluations; determining subordinates' training needs and providing or arranging for such training; motivating subordinates to work effectively; determining the need for disciplinary action and either recommending or initiating disciplinary action. • 3 years experience in working in a PCI-DSS credit card environment. • Knowledge of secure coding techniques, Active Directory, patching using SCCM etc. • Additional IT experience as a programmer, system administrator or network engineer preferred • McAfee EPO • Rapid 7 • Websense • Knowledge of the principles, practices and techniques of supervision. • Knowledge of the laws, rules, regulations, policies, procedures, specifications, standards and guidelines governing assigned unit activities. ** ** MINIMUM REQUIRMENTS • BA or BS in Computer Science, Management Information Systems, or related field. Advanced degree desirable. • Five+ years of progressive experience in computing and information security, including experience with Internet technology and security issues. ** ** LICENSE AND/OR CERTIFICATION REQUIRMENTS • CISSP or CISA certification • Based on assignment, possession of a current and valid Class 3 Motor Vehicle Operator's License may be required. ** ** ** ** ** ** ** ** Thanks, **Ankush Chaudhary** ** **Software People Inc. www.softwarepeople.us ankush.chaudh...@softwarepeople.us Ph: 631- 739-8494 Fax: 631-574-3122 *Certifications: SBA 8a/SDB,NJ MWBE, NY MWBE, VA SWaM, DE OMWBE*** ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email