Results 1 to 4 of 4

make a named range from cell value?

Threaded View

  1. #1
    Registered User
    Join Date
    03-16-2012
    Location
    florida
    MS-Off Ver
    mac 2008
    Posts
    63

    make a named range from cell value?

    i was trying to do something like this:
    Sub Button4_Click()
    '
    ' Button4_Click Macro
    '
    
    '
        Range("A16").Select
        Selection.Copy
        Application.CutCopyMode = False
        Selection.Copy
        Range("E4:E20").Select
        Application.CutCopyMode = False
        ActiveWorkbook.Names.Add Name:="bears", RefersToR1C1:="=Sheet1!R4C5:R20C5"
        Range("A17").Select
        Selection.Copy
        Range("F4:F20").Select
        Application.CutCopyMode = False
        ActiveWorkbook.Names.Add Name:="broncos", RefersToR1C1:= _
            "=Sheet1!R4C6:R20C6"
    End Sub
    but instead of "bears" or "broncos" it would take the cell value from cell A16 and A17 to make those named ranges. is there a way to do that? thanks!
    Last edited by tsiguy96; 09-11-2014 at 01:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] determining if cell is part of named range and what that named range is
    By stnkynts in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2014, 07:56 PM
  2. [SOLVED] Determining if the value of a cell can be a named range, then assigning named ranges after
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-15-2013, 06:05 PM
  3. Replies: 3
    Last Post: 04-19-2013, 01:24 PM
  4. Replies: 1
    Last Post: 02-27-2013, 12:00 AM
  5. Replies: 1
    Last Post: 06-03-2006, 10:55 PM

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