Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create range in udf
Hello
Is it possible for a UDF to dimension a named range to work with inside a UDF, I need to create a named range so I can pass it into the sumifs function withing the UDF. I have all the other args for the sumifs but arg1 is dynamic and this is the bit i'm stuck on. This is what I have so far. .... Dim SearchColumn As Range .... SearchColumn = ???? (To be Sheets(1).Range(cells(1,x%),cells(y%,x%)) .... result = WorksheetFunction.SumIfs(SearchColumn, Column1Range, Column1Criteria, Column2Range, Column2Criteria) .... ICTSumIf = result Any ideas Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create range in udf
udf can reference (read) anything in any workbook, but has limited write
capabilities. I like to pass ranges in to UDF's. =myfunction(A1:B4) or =myfunction(columns(1:3)) function myfunction(Myrange as Range) for each cell in Myrange .your code next cell result = WorksheetFunction.SumIfs(MyRange, Column2Criteria) end function "Cresta" wrote: Hello Is it possible for a UDF to dimension a named range to work with inside a UDF, I need to create a named range so I can pass it into the sumifs function withing the UDF. I have all the other args for the sumifs but arg1 is dynamic and this is the bit i'm stuck on. This is what I have so far. ... Dim SearchColumn As Range ... SearchColumn = ???? (To be Sheets(1).Range(cells(1,x%),cells(y%,x%)) ... result = WorksheetFunction.SumIfs(SearchColumn, Column1Range, Column1Criteria, Column2Range, Column2Criteria) ... ICTSumIf = result Any ideas Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a Range Name? | New Users to Excel | |||
How do I create this range? | Excel Programming | |||
Create named range | Excel Programming | |||
Create/copy combo boxes in one range if condition is met in a different range | Excel Programming | |||
Create named range | Excel Programming |