Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a range name from Selection.CurrentRegion.Select
I have a user who tracks his time in Excel. He recorded a macro which sorts
the worksheet according to job number. But, he wants the macro to work with any of his worksheets within any workbook. Therefore, I changed the beginning of the lines in the macro to: ActiveSheet instead of a specific sheet. Then, I have the macro move the active cell cursor to A1 and do a "Selection.CurrentRegion.Select", which selects the region. Next, I want to name the range. However, when I do that, I'm coming up with a boolean. This does me no good, since I want to use the NamedRange to tell the sort command what to sort. How can I convert the command, "Selection.CurrentRegion.Select" to a Named Range? Thank you for any help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error with Selection.CurrentRegion.Rows.Count? | Excel Programming | |||
Range(Selection, Selection.End(xlToRight)).Select | Excel Programming | |||
How to select the bottom right cel in a 'CurrentRegion.selecion' | Excel Programming | |||
Select first row of currentregion | Excel Programming | |||
Select a range in a column in currentregion | Excel Programming |