Offset does not have to be volatile

[bines53]

Hello friends,

I want to share with you, EXCEL ADD IN, language C ++, functions XlOffset, XlToday are not volatile like Excel, do not know if it is the same as Excel.



David

 

[Marc L]

Hi !

Bad link ! Can you check your link after re-post it, thanks …
​

 

[bines53]

Hi Marc L,

I see that there is a problem with the link, the solution is to copy it
https://tkljh.s3.amazonaws.com/quant/tools/excel.html

David

 

[Marc L]

This one seems to well works this time on my side …
​

 

[bines53]

XlSelect ,As the INDEX function, but more flexible,
=XlSelect($B1:B10,{1,3}) To do it with INDEX , it's more complicated
=INDEX($B1:B10,{1,3})

David