Author Archives: dougaj4

Worksheetfunction.Transpose – changed behaviour in Excel 2013 and 2016

Posted on 01/01/2016 by dougaj4

It is (fairly) well known that when using Worksheetfunction.Transpose on an array in VBA the array must be no more than 65,536 (2^16) rows long, or it will return an error. Recently when using Excel 2016 (32 bit) I thought … Continue reading →

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

Opening and searching pdf files from Excel

Posted on 30/12/2015 by dougaj4

The file PdfLink.zip (free download with open source code) contains two short but useful macros for opening and searching pdf files from Excel. The first is based on code from My Engineering World. I have just added a simple interface … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , , , | 10 Comments

Excel Summit South Reminder

Posted on 29/12/2015 by dougaj4

I have just signed up for the Excel Summit South. Anyone wanting a 20% discount has until Thursday 31st December.    

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

Boxing Day on the James Craig

Posted on 27/12/2015 by dougaj4

The James Craig is a 19th Century square rigger, restored by the Sydney Heritage Fleet, which makes regular sailings from Sydney Harbour open to the public, including a Boxing Day trip to observe the departing Sydney-Hobart race: The crew (all volunteers) … Continue reading →

Posted in Bach | Tagged , , , , | Leave a comment

More on Sums

Posted on 18/12/2015 by dougaj4

My post from last week, on using the Aggregate function to find the maximum and minimum of a range ignoring errors, was linked in the Contextures Blog’s weekly roundup, which also linked to the Contextures page of Sum Function examples.  This includes … Continue reading →

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