Get Excel selection address [Solved]

[ahha]

I'm using the excellent _Excel UDF to read a whole spreadsheet into an array I want to operate on.  I can read a specified range without a problem.  What I'd like to do is allow the user in Excel to select a range (contiguous is fine) and be able to read that range so that I know what range to operate on without having the user input the range via a keyboard.  I'm stuck and any hints greatly appreciated.  The code below uses the Helpfile .xls to illustrate where I crash.

;
#AutoIt3Wrapper_run_debug_mode=Y    ; use this to debug in console window <--- LOOK

#include <Excel.au3>
#include <MsgBoxConstants.au3>
#include <Debug.au3>    ;for _DebugArrayDisplay

$sExcelFullFileName = "C:\Program Files (x86)\AutoIt3\Examples\Helpfile\Extras\_Excel1.xls"     ;use Autoit test for example

$oExcel = _Excel_Open() ;Create application object and open an Excel workbook
$oWorkbook = _Excel_BookOpen($oExcel, $sExcelFullFileName)
$aExcelArray = _Excel_RangeRead($oWorkbook, Default)
_DebugArrayDisplay($aExcelArray, $aExcelArray)  ;let's look at it
$aI5K6 = _Excel_RangeRead($oWorkbook, Default,"I5:K6")  ;read a rangeI5:K6 and return value
_DebugArrayDisplay($aI5K6, $aI5K6)  ;let's look at range it

;rather than defining the range explicity I'd like to read the selection in Excel and use it
;need a function like _Excel_SelectionRead
;try hacking Excel.au3 _Excel_RangeRead to see if can create _Excel_SelectionRead  looks like .Selection .Value .Text and .Address possible
MsgBox($MB_SYSTEMMODAL, "Info", "Select cells in Excel then click OK")

;ACTUALLY get range of the selection and this will suffice for us to use on the $aExcelArray
$vRange = $oWorkbook.ActiveSheet.Selection.Address($vRange)
;tried all sorts of permutations and clearly I need help
_DebugArrayDisplay($vRange, $vRange)    ;let's look at range it

;$vResult = $oExcel.Transpose($vRange.Value)
;_DebugArrayDisplay($vResult, $vResult) ;let's look at range it

_Excel_Close($oExcel, False, True)
Exit

 

Edited October 28, 2018 by ahha
solved

[water]

$oExcel.Selection returns the range selected by the user.
See: https://docs.microsoft.com/de-de/office/vba/api/excel.application.selection

[ahha]

Water thanks!

$vRange = $oExcel.Selection.Address

got me what I needed.