Re: $$Excel-Macros$$ Macro to delete a specific sheet by specifying *

PERFECT 100% thanks to All On Tue, Jan 29, 2013 at 12:49 PM, NOORAIN ANSARI wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (noorain.ans...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Macro to delete a specific sheet by specifying

Hi Hilary, You can try.. Sub delete_specific_Sheet() Dim sh As String sh = VBA.InputBox("Please Enter sheet Name") Application.DisplayAlerts = False Worksheets(sh).Delete Application.DisplayAlerts = True End Sub On Tue, Jan 29, 2013 at 6:15 PM, Hilary Lomotey wrote: > sub detele() > > Applica

Re: $$Excel-Macros$$ Macro to delete a specific sheet by specifying

to delete a specific sheet by specifying sub detele() Application.DisplayAlerts = False Worksheets("Sheet1").delete Application.DisplayAlerts = True end sub Hello Experts, the code above deletes sheets1 but this is a static macro , i want to be able to delete a sheet by type the she

$$Excel-Macros$$ Macro to delete a specific sheet by specifying

sub detele() Application.DisplayAlerts = False Worksheets("Sheet1").delete Application.DisplayAlerts = True end sub Hello Experts, the code above deletes sheets1 but this is a static macro , i want to be able to delete a sheet by type the sheetname and then have it deleted, kindly assist with