Category Archives: Excel

Getting help in 2013

Posted on 30/04/2014 by dougaj4

Getting help in Excel 2013 takes you by default to the Microsoft on-line help files, which is not only much slower than connecting to a local file, when you get there finding what you want is even slower. From the … Continue reading →

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

Displaying range names

Posted on 28/04/2014 by dougaj4

A useful tip, brought to you from Bob Umlas, via Mike Alexander: If you want to display the named ranges in a spreadsheet, one way is to open the Name Manager (from the Formulas ribbon).  Another is to press F3, … Continue reading →

Posted in Excel | Tagged , , | 1 Comment

More Sort Functions

Posted on 23/04/2014 by dougaj4

I have recently added three new sorting User Defined Functions (UDFs) to the SortFunc-py spreadsheet, and added a new option to the SortV function.  The new file may be downloaded from SortFunc.zip, including full open source code. The first new function … Continue reading →

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

ConBeamU Update

Posted on 17/04/2014 by dougaj4

Recently a comment pointed out that if the ConBeam, or ConBeamU, user defined functions were used with a single span then the “Out” argument was ignored, so it was not possible to return support reactions.  This has now been fixed … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , | 18 Comments

“Yields circularity when preceded by its quotation” …

Posted on 15/04/2014 by dougaj4

yields circularity when preceded by its quotation. Today’s post takes us on a little circular tour of the internet, starting with: Grumpy Old Programmer (Mike Woodhouse) who returns from a long holiday from blogging to publish a nice little routine … Continue reading →

Posted in Computing - general, Drawing, Newton | Tagged , , , , , | Leave a comment