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 naukrikuld...@gmail.comwrote:
Hi Experts,
I want to
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 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
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 naukrikuld...@gmail.comwrote:
Hi Experts,
I want to create sheets by given name (Via VBA). anyone please help me.
naukrikuld...@gmail.com
To: excelvbacli...@googlegroups.com; excel-macros@googlegroups.com
excel-macros@googlegroups.com
Sent: Fri, April 26, 2013 9:57:23 AM
Subject: $$Excel-Macros$$ Create Sheets by given name.
Hi Experts,
I want to create sheets by given name (Via VBA). anyone please