Naming Current Region

Discussion in 'Microsoft Excel Misc' started by Gavin, Oct 14, 2003.

  1. Gavin

    Gavin Guest

    Hi there,
    Can someone please help with a simple macro query I have.
    I need to add a name to the current region selected, such
    that I can use this name in later actions. The region can
    vary in size and hence I can't reference a cell range.
    I'm a bit of a beginner when it comes to macros in Excel,
    however I would have thought that I needed a command such
    as: ActivWorkbook.Names.Add Name:="The Name",
    RefersTo:CurrentRegion
    or somesuch. Any advice would be appreciated.
     
    Gavin, Oct 14, 2003
    #1
    1. Advertisements

  2. Gavin

    Gavin Guest

    Sorry, this should have gone in the programming forum.
    Have now copied it into there. Please delete or ignore as
    appropriate.

    >-----Original Message-----
    >Hi there,
    >Can someone please help with a simple macro query I have.
    >I need to add a name to the current region selected, such
    >that I can use this name in later actions. The region can
    >vary in size and hence I can't reference a cell range.
    >I'm a bit of a beginner when it comes to macros in Excel,
    >however I would have thought that I needed a command such
    >as: ActivWorkbook.Names.Add Name:="The Name",
    >RefersTo:CurrentRegion
    >or somesuch. Any advice would be appreciated.
    >.
    >
     
    Gavin, Oct 14, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. yosi

    Select the currebt region

    yosi, Aug 14, 2003, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    219
    Debra Dalgleish
    Aug 14, 2003
  2. Bart

    Pasting into a filtered region

    Bart, Jan 13, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    269
    Debra Dalgleish
    Jan 13, 2004
  3. Guest

    Data Region & Auto Complete

    Guest, Mar 24, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    438
    Bernie Deitrick
    Mar 24, 2004
  4. Dave Peterson

    Re: Solution? Auto Complete & Data Region

    Dave Peterson, Mar 31, 2004, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    271
    Guest
    Apr 7, 2004
  5. themax16

    Is it possible to count if within a number region?

    themax16, May 22, 2005, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    172
    Bob Phillips
    May 22, 2005
  6. Replies:
    0
    Views:
    198
  7. ManhattanRebel

    Current Region..Cntrl Asterick

    ManhattanRebel, Nov 27, 2009, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    182
    Jacob Skaria
    Nov 27, 2009
  8. Grey Old Man

    Current year and current week number

    Grey Old Man, Dec 6, 2009, in forum: Microsoft Excel Misc
    Replies:
    9
    Views:
    483
    Grey Old Man
    Dec 8, 2009
Loading...