+ Reply to Thread
Results 1 to 3 of 3

Referring to a range

  1. #1
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Referring to a range

    Heya! There is a general question. I dont understand how, writing a UDF, to refer and to declare a range that later will be chosen by user as his wish. Meaning the arguments will be chosen by user from any place on the sheet. How to refer to it and to declare it. Thanks in advance!

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,350

    Re: Referring to a range

    Just for an example
    Please Login or Register  to view this content.
    Here the 'rng' argument - a range that user can select anywhere on the sheet. And the formula will look like this:
    =SumMoreOneOnly(A1:A10)

  3. #3
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Referring to a range

    Thank you nilem! i'll try it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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