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.

>-----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.
>.
>