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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks