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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. yosi

    Select the currebt region

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

    Pasting into a filtered region

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

    Data Region & Auto Complete

    Guest, Mar 24, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    362
    Bernie Deitrick
    Mar 24, 2004
  4. ManhattanRebel

    Current Region..Cntrl Asterick

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

    Current year and current week number

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

Share This Page