Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1

2012-10-07 Thread chhajersandeep
Sent on my BlackBerry® from Vodafone -Original Message- From: ashish koul koul.ash...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 7 Oct 2012 11:23:29 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for Insert

Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1

2012-10-07 Thread chhajersandeep
Thanks Swapnil. Its working fine. It will be beneficial to us if you may try to explain the code. :) Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Swapnil Palande palande.swapni...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 7 Oct 2012

Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1

2012-10-07 Thread chhajersandeep
Swapnil I am getting a problem when ever I am trying to change any of the sheet it is saying run time error 9 code out of range. Can it be fixed? Thanks in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Date: Sun, 7 Oct

$$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1

2012-10-06 Thread chhajersandeep
Dear all, Good Morning. I want a macro which can create/ insert/ or delete worksheet according to the list prepared in sheet1. Like if I delete a name from the list the corresponding sheet will be deleted or if I insert a name in the list it will create a sheet with the same name. It will be

Re: $$Excel-Macros$$ Macro for Insert and delete worksheets according the list in sheet1

2012-10-06 Thread ashish koul
share the sample file On Sun, Oct 7, 2012 at 11:22 AM, chhajersand...@gmail.com wrote: Dear all, Good Morning. I want a macro which can create/ insert/ or delete worksheet according to the list prepared in sheet1. Like if I delete a name from the list the corresponding sheet will be