Posted to microsoft.public.excel.programming

Luc[_8_]

external usenet poster

Posts: 13

ActiveWorkbook.Names.Add Name ???

2 Questions :

1 How do i refer to the cells wich are currently selected ?

So, i want to assign a name to the cells which are selected.

2 Is it possible to assign the same name to ranges in different worksheets ?
Example : i have sheets "Step 1" to......"Step xx"
I want a name assigned to a range in "Step 1", but that name can also
exist in the sheet "Step 1" or "Step xx".

Thanks,

Luc

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get Names of ActiveWorkbook.CustomViews	cellist	Excel Programming	2	April 30th 08 07:02 AM
ActiveWorkbook.Names.Add -- Problem	Ger[_3_]	Excel Programming	6	February 23rd 07 09:32 AM
Mutiple names in ActiveWorkbook.SendMail Recipients:=	daleatshel	Excel Discussion (Misc queries)	2	February 5th 07 08:06 PM
'ActiveWorkbook.Names.Add Name:' how to make range variable?	TeeSea	Excel Programming	1	June 9th 05 03:42 PM
Using ActiveWorkbook.Names.Add Name:=	Stuart[_5_]	Excel Programming	2	November 15th 03 02:38 PM

All times are GMT +1. The time now is 01:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us