Tag Archives: offset

Excel functions that return references and new functions

The MyOnlineTrainingHub blog recently posted an article on: Excel Functions that Return References As well as comprehensive advice on the use of OFFSET, INDEX, CHOOSE, IF and INDIRECT, it also covers the new functions XLOOKUP (Excel for Microsoft 365 only), and … Continue reading

Posted in Arrays, Excel | Tagged , , , , , , , , , | 1 Comment

Slicing Arrays with VBA

A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | 7 Comments