Results 1 to 4 of 4

Sheet Name = a Cell

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    Cullman, Alabama
    MS-Off Ver
    2010
    Posts
    31

    Sheet Name = a Cell

    Trying to get the sheet name to be the cell C1


    Sub New_Shooter()
    '
    ' New_Shooter Macro
    '
    
    '
        Sheets("Blank Form").Select
        Cells.Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets.Add After:=c1
        ActiveSheet.Paste
    End Sub
    Last edited by Jarrettm; 04-17-2015 at 10:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] syntax to select cell in another sheet based on offset of active cell in current sheet
    By duvius in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-07-2014, 11:16 AM
  2. [SOLVED] read single cell content from sheet of closed file and put it in a cell on an active sheet
    By rsmith5413 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2014, 04:16 AM
  3. Replies: 2
    Last Post: 11-18-2013, 07:31 AM
  4. [SOLVED] Locating a cell in sheet 2, based on 2 variables in sheet 1. Result into sheet 1.
    By Gezza24 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-05-2013, 12:50 AM
  5. Replies: 13
    Last Post: 04-04-2012, 01:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1