| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF and dynamic range
I have a function I built in which a couple of the inputs require a range...
I would like to have that range be dynamic so that sometimes it select 4 dates or sometimes only 3... So I tried to put this in for my function (I16:OFFSET($I$16,H15-1,0))... but that doesn't work. If I have I16:I19 the function works fine... can I put this offset in code in my function? is that clear? any thoughts are appreciated. excel 2007 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UDF and dynamic range
Please post the code of your function
-- Kind regards, Niek Otten Microsoft MVP - Excel "John" wrote in message ... |I have a function I built in which a couple of the inputs require a range... | I would like to have that range be dynamic so that sometimes it select 4 | dates or sometimes only 3... So I tried to put this in for my function | (I16:OFFSET($I$16,H15-1,0))... but that doesn't work. If I have I16:I19 the | function works fine... can I put this offset in code in my function? | | is that clear? any thoughts are appreciated. excel 2007 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UDF and dynamic range
I got it, sorry for the trouble
"Niek Otten" wrote: Please post the code of your function -- Kind regards, Niek Otten Microsoft MVP - Excel "John" wrote in message ... |I have a function I built in which a couple of the inputs require a range... | I would like to have that range be dynamic so that sometimes it select 4 | dates or sometimes only 3... So I tried to put this in for my function | (I16:OFFSET($I$16,H15-1,0))... but that doesn't work. If I have I16:I19 the | function works fine... can I put this offset in code in my function? | | is that clear? any thoughts are appreciated. excel 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic range based on criteria, within a dynamic range, passed to a function | Excel Programming | |||
| creating a dynamic range based on criteria, within a dynamic range, and passing it to a function | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| copying dynamic range based on cell outside of range | Excel Programming | |||
| select dynamic range with dynamic start point | Excel Programming | |||
Hybrid Mode
