Results 1 to 5 of 5

User Defined Functions: can control what named ranges get used?

Threaded View

djt76010 User Defined Functions: can... 11-21-2008, 08:07 PM
shg You could use an InputBox and... 11-21-2008, 08:09 PM
djt76010 Oops . . . I wasn't quite... 11-21-2008, 08:18 PM
shg That's not going to happen. ... 11-21-2008, 08:25 PM
djt76010 I had a feeling that would be... 11-21-2008, 08:26 PM
  1. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    You could use an InputBox and allow people to choose from a list of ranges. But is if really is a UDF and not a sub, that's a very bad idea, becase the UDF will only recalculate when one of its passed arguments changes.
    Last edited by shg; 11-21-2008 at 08:11 PM.
    Entia non sunt multiplicanda sine necessitate

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1