PC Review


Reply
Thread Tools Rate Thread

Naming Current Region

 
 
Gavin
Guest
Posts: n/a
 
      14th Oct 2003
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.
 
Reply With Quote
 
 
 
 
Gavin
Guest
Posts: n/a
 
      14th Oct 2003
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.
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Region visible in another Region? Brian Basquille Microsoft C# .NET 2 7th Feb 2005 06:05 PM
Examples using Region and/or Region.Intersect? Brian Microsoft C# .NET 3 17th Dec 2004 03:05 PM
region - end region =?Utf-8?B?Z3V5?= Microsoft VB .NET 3 22nd Oct 2004 12:38 PM
region 2 dvd wont play on dvd player region 2 in win xp John Windows XP New Users 2 14th Dec 2003 02:50 PM
Naming Current Region Gavin Microsoft Excel Programming 3 14th Oct 2003 03:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:14 PM.