Naming Current Region

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

Gavin

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

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming Current Region 3
Macro changing region names 2
Defining Regions with Names 3
Macro to insert and move columns 3
creating regional summary data 2
Filtering without filtering 4
Outlook Outlook: Region disappears when form is sent 3
How do I make a rank equation that omits particular cells? 1

Top