1/ Create one sheet
Sub CreateSheet()
Worksheets.Add
End Sub
2/ Remove 1 sheet named "THANH", and create a new one sheet called "TRUNG"
Sub CreateSheet()
On Error Resume Next
Application.DisplayAlerts = False
Sheets("THANH").Delete
On Error GoTo 0
Worksheets.Add
Hi Kuldeep,
You can also try this.
Sub CreateSheet()
For Each rngCell In Selection
ThisWorkbook.Worksheets.Add.Name = rngCell.Value
Next rngCell
End Sub
Regards
Priti verma
On Fri, Apr 26, 2013 at 7:26 PM, Kuldeep Singh wrote:
> Hi Experts,
>
> I want to create sheets by give
e places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Kuldeep Singh
To: excelvbacli...@googlegroups.com; "excel-macros@googlegroups.com"
Sent: Fri, April 26, 2013 9:57:23 AM
Subject: $$Excel-Macros$$ Create Sheets by given
Hi Kuldeep,
Please find attached...need u add more sheet name just change range name
.
Enjoy
Team XLS
On Fri, Apr 26, 2013 at 7:26 PM, Kuldeep Singh wrote:
> Hi Experts,
>
> I want to create sheets by given name (Via VBA). anyone please help me.
>
> Regards,
> Kuldee
Hi Experts,
I want to create sheets by given name (Via VBA). anyone please help me.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e
