Results 1 to 2 of 2

Thread: Selected range while creating formula

  1. #1

    Selected range while creating formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi.
    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?
    TIA

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,350
    Articles
    0
    Excel Version
    365
    cross posted without links:

    https://social.msdn.microsoft.com/Fo...forum=exceldev
    http://www.msofficeforums.com/excel-...g-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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •