LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 298
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error with Selection.CurrentRegion.Rows.Count? KenY Excel Programming 2 April 21st 10 11:01 AM
Range(Selection, Selection.End(xlToRight)).Select Dave Birley Excel Programming 2 June 6th 07 04:53 PM
How to select the bottom right cel in a 'CurrentRegion.selecion' Luc Excel Programming 3 March 3rd 07 07:58 PM
Select first row of currentregion vba Excel Programming 4 July 19th 06 01:16 PM
Select a range in a column in currentregion ward376 Excel Programming 6 March 14th 06 02:25 PM


All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"