Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
I'm trying to define a named range based on the selection. The help covers the following simple scenario. ActiveWorkbook.Names.Add Name:="myName", RefersToR1C1:= _ "=Sheet1!R1C1" Can someone please show me how to change this based on the currently selected range? Thanks, Todd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
If you're doing it manually (ie not through VBA) then just hit cntrl-F3 and
it will give you a "Define Name" window. here just choose a name and then it's like making a graph, just click where you want to define your range. Cheers, Scott "T. Jenkins" wrote: I'm trying to define a named range based on the selection. The help covers the following simple scenario. ActiveWorkbook.Names.Add Name:="myName", RefersToR1C1:= _ "=Sheet1!R1C1" Can someone please show me how to change this based on the currently selected range? Thanks, Todd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
Selection.Name="myName"
HTH Otto "T. Jenkins" wrote in message ... I'm trying to define a named range based on the selection. The help covers the following simple scenario. ActiveWorkbook.Names.Add Name:="myName", RefersToR1C1:= _ "=Sheet1!R1C1" Can someone please show me how to change this based on the currently selected range? Thanks, Todd |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
Selection.Name:="myName"
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "T. Jenkins" wrote in message ... I'm trying to define a named range based on the selection. The help covers the following simple scenario. ActiveWorkbook.Names.Add Name:="myName", RefersToR1C1:= _ "=Sheet1!R1C1" Can someone please show me how to change this based on the currently selected range? Thanks, Todd |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Range
This code takes the used range of a spreadsheet and assigns a name of
Database to it. Useful for pivot tables or advanced filtering. Courtesy of Debra Dalgleish Public Sub SetNamedRange() ActiveWorkbook.Names.Add NAME:="Database", _ RefersTo:=Worksheets("Data").UsedRange End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
If any cell in named range = 8 then shade named range | Excel Programming |