Naming Current Region

  • Thread starter Thread starter Gavin
  • Start date Start date
G

Gavin

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.
 
Sorry, this should have gone in the programming forum.
Have now copied it into there. Please delete or ignore as
appropriate.
 
Back
Top