Author Archives: dougaj4

Ranges and Arrays – 2

Posted on 05/03/2008 by dougaj4

Yesterday we looked at how to get data from a worksheet range into a VBA array.  Today’s post looks at the opposite operation; writing an array to a worksheet range.  With a UDF it couldn’t be simpler: Function MyFunction() as … Continue reading →

Posted in Arrays, Excel, UDFs | 1 Comment

Ranges and Arrays

Posted on 04/03/2008 by dougaj4

Transferring data from a worksheet into a VBA routine, or the other way round, is one of the most frequent tasks carried out in VBA programming.  Fortunately there is a simple way to do it: In a subroutine: Name the … Continue reading →

Posted in Arrays, Excel, UDFs | Tagged , , , | 4 Comments

Crab Canon

Posted on 01/03/2008 by dougaj4

And talking of left and right, here is an appreciation of Douglas Hofstadters’s “Godel Escher Bach” (from which this blog takes its name): Godel Escher Bach wherein we find the excellent Crab Canon: Crab Canon

Posted in Bach | Tagged , , | 1 Comment

Alice Through the Looking Glass, or How to Shake Hands With an Alien

Posted on 01/03/2008 by dougaj4

An interesting article on the handedness of amino acids: Mirror, Mirror « Girl Meets Science and a somewhat tenuously linked discussion about how to describe left/right to an alien: http://www2b.abc.net.au/science/k2/stn/newposts/3400/topic3400503.shtm

Posted in Newton | 1 Comment

Theme Music?

Posted on 29/02/2008 by dougaj4

Galaxy Dynamics by John Dubinski  “… Gravitas points clearly at ties between the ideas of Isaac Newton and the music of Bach. To do this with sounds and images that appeal to club kids and new music fans equally is … Continue reading →

Posted in Bach, Newton | Leave a comment