Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Address of selected range
I have the following VBA code (it was recorded):
dim chrtrng as range Range("j2").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select set chrtrng = selection.address ~~~~~~~ I now wish to know how to assign that range a name. The above set does not work and I can't quite figure the correct way to do this. Thanks for any help. Pieter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
Lower right cell address in a selected range - Excel 2007 | Excel Programming | |||
Get selected cell name/address | Excel Programming | |||
How do I convert a selected Cell address in a Range to Values? | Excel Programming | |||
How do you get a Selected Range address into a variable? | Excel Programming |