Announcement

Collapse
No announcement yet.

Add Sheet Named As Cell Value If Not Present Already

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Add Sheet Named As Cell Value If Not Present Already

    I have 1 workbook is Quotation and already created a "Save Button" for correct all worksheet into 1 workbook. When after click save i need excel create a new worksheet with a no. based on specific cell is "K17"(QT no.) and check duplicate. Thank you in advance for the suggestion.

  • #2
    Re: Create A New Worksheet With Specific Cell

    English is 1st language? Righto.

    Can you please expand your question a little more? We will find it very hard to help unless we understand what you need.

    Comment


    • #3
      Re: Create A New Worksheet With Specific Cell

      Hi,

      May be..
      Dim ShtName As String, NewSht   As Worksheet
      ShtName = Range("K17")
      On Error Resume Next
      Set NewSht = Sheets(ShtName)
      On Error GoTo 0
      If NewSht Is Nothing Then
      Set NewSht = Worksheets.Add
      NewSht.Name = ShtName
      Else
      MsgBox "Sheet '" & ShtName & "' already exists", vbInformation
      End If
      Kris

      ExcelFox

      Comment

      Working...
      X