Comments for RAD Excel https://colinlegg.wordpress.com Wed, 27 Jan 2021 01:15:01 +0000 hourly 1 http://wordpress.com/ Comment on Self Extending UDFs – Part 1 by Colin Legg https://colinlegg.wordpress.com/2014/08/25/self-extending-udfs-part-1/#comment-7822 Wed, 27 Jan 2021 01:15:01 +0000 http://colinlegg.wordpress.com/?p=1751#comment-7822 Hi KH, sorry about the ribbon error. IIRC, I tested it in 2007 and 2010 32-bit at the time of posting, but I haven’t maintained it since then. I haven’t coded in VBA for quite a few years now. :)

Like

]]> Comment on Self Extending UDFs – Part 1 by KH https://colinlegg.wordpress.com/2014/08/25/self-extending-udfs-part-1/#comment-7821 Tue, 26 Jan 2021 23:50:32 +0000 http://colinlegg.wordpress.com/?p=1751#comment-7821 In reply to Colin Legg.

Hi Colin – Very often I need to deploy my apps to some other client PCs on my team that load only Excel 2016 which doesn’t have the spill / dynamic array features. I prefer your solution as it gives me flexibility in managing the “spill” range :)

The same error happened when the add-in was loaded on Excel 2016, but I could live with that since the UDFs are working correctly. Thanks again Colin !!

Like

]]> Comment on Self Extending UDFs – Part 1 by Colin Legg https://colinlegg.wordpress.com/2014/08/25/self-extending-udfs-part-1/#comment-7819 Tue, 26 Jan 2021 17:07:35 +0000 http://colinlegg.wordpress.com/?p=1751#comment-7819 In reply to KH.

Hi KH, these UDFs were written 7 years ago – the spill / dynamic array features in Excel 365 would make these UDFs redundant?

Like

]]> Comment on Self Extending UDFs – Part 1 by KH https://colinlegg.wordpress.com/2014/08/25/self-extending-udfs-part-1/#comment-7814 Tue, 26 Jan 2021 14:19:14 +0000 http://colinlegg.wordpress.com/?p=1751#comment-7814 Hi there, these UDFs are useful but I encountered an issue after installing the add-in on Excel for Office 365 (32-bit)… I was able to call both rxlRESIZE() and rxlEXTEND, but the ribbon had failed to load. Got an error prompt stating just “400”. It wasn’t a deal-breaker but I am curious to learn what would have caused the error to not show the ribbon.

Thanks for the outstanding work on this !!

Like

]]> Comment on How To Calculate The Next IMM Date by John https://colinlegg.wordpress.com/2012/06/04/how-to-calculate-the-next-imm-date/#comment-7761 Sat, 16 Jan 2021 09:01:54 +0000 http://colinlegg.wordpress.com/?p=551#comment-7761 Hello, It seems like that there is something wrong with the formula.=DATE(YEAR(A2);CEILING(MONTH(A2)+(DAY(A2)>20);3);20). For example, the date in A2 is 2020-12-10, then it shows that the next IMM date is 2020-12-20. However, this was a Saturday. Therefore,shouldn’t the date move forward to 2020-12-19?

Like

]]>