Tag Archives: Index

Slicing Arrays with VBA

Posted on February 20, 2015 by

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

Using Index() as an array function

Posted on June 23, 2013 by

As promised, this post looks at using the Excel built in Index() function to operate on arrays; it also provides a VBA user defined function (UDF), VBIndex, which simplifies working with arrays within VBA, and also provides improved functionality when … Continue reading →

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

Two new blogs

Posted on June 17, 2013 by

Two new Excel/computer related blogs that I have found recently are: Useful Gyaan (Sharing Stuff to Make life @ work easier) and MS EXCEL UNPLUGGED (which looks like a good resource on using pivot tables) In the near future I will be … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , | Leave a comment