#1
|
|||
|
|||
UDF data type errors
Having trouble figuring out how to express this function. The argument I'm entering into the formula is a cell which references the name of the tab that has the range I'm looking to grab data from. Then I'd like to add up the data found in that range as my output from this formula.
Function testnamedrange(DNRange As String) As Variant Dim rng As Range Set rng = Range("" & DNRange&, "!$e$17:$p$17") testnamedrange = "=Sum(rng)" End Function |
Tags |
range object, type, udf |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create a Main category mirrored in Sub category data entry type of solution? | Geza59 | Excel | 0 | 10-19-2012 05:44 AM |
Please help! lots of errors | tundrawolf | Office | 7 | 04-24-2012 08:50 PM |
HELP PLEASE - personal free / busy data errors | david@memories | Outlook | 2 | 03-03-2011 09:45 AM |
COM Automation Errors | ivanm | Word | 0 | 03-23-2009 07:02 PM |
How do you fix ost in use errors? | enviroko | Outlook | 0 | 10-23-2008 09:49 AM |