Selected range while creating formula

[FONT=&quot]Hi.[/FONT]
[FONT=&quot]I need to get the selected range while I am creating a formula. For example, I create the formula =SUM(A1:A10). How can I get the A1:A10 range? There is any Excel interop property that provides me the A1:A10 range?[/FONT]
[FONT=&quot]TIA[/FONT]

cross posted without links:

https://social.msdn.microsoft.com/F...d-range-while-creating-formula?forum=exceldev
http://www.msofficeforums.com/excel...-cells-referenced-while-creating-formula.html

jariquelme, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184