Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Code Naming a Range (range changes each time)
Can somehere tell me how to name a range in excel using VB code. Here'
how I get the range: Range("L1").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False As u can see the range changes, but I would like to create the sam name for whatever the range is? Thanks.. Krazylai -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign a code to a range of time | Excel Worksheet Functions | |||
Naming a range with VBA... | Excel Programming | |||
Naming a range | Excel Programming | |||
Range naming | Excel Programming | |||
Code for naming worksheet name range?? | Excel Programming |