Prev Previous Post   Next Post Next
  #1   Report Post  
Thrava
 
Posts: n/a
Default SELECTION()

Hello everyone.

I cam accross the function SELECTION(), while reading the
web page "Daily dose of Excel" http://www.dicks-
blog.com/archives/category/worksheet-functions/

The section regarding calculating with the selected range.
there, you define the name Sel_Range with the formula:
=MID(CELL("address",($A$1,SELECTION())),6,255.....

I tried to find more information on the function SELECTION
(), but there's nothing listed in excel help. typing the
function in a cell gives an error, but typing the formula
in the define name seems to take the formula.

Any idea what this SELECTION() is/ does?

Thanks

 
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
How can I set up the random selection of a cell from within a ran. nybbac Excel Discussion (Misc queries) 5 January 1st 05 05:39 AM
How can I get a macro in Excel to set the Zoom to "Selection"? GarryH Excel Discussion (Misc queries) 2 December 21st 04 01:44 PM
Date Selection for Pivot Table Burak Emer Excel Discussion (Misc queries) 0 December 15th 04 08:19 AM
Disable menu selection andy Excel Discussion (Misc queries) 3 December 10th 04 10:46 PM
Paper Tray selection Problem, Michael Hoffmann Excel Discussion (Misc queries) 4 December 3rd 04 09:08 PM


All times are GMT +1. The time now is 10:11 AM.

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

About Us

"It's about Microsoft Excel"