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