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

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

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