Recent Comments
Tag Archives: VBA
Transferring data within VBA
The use of inappropriate techniques for passing data between sub-routines and modules is probably one of the most frequent causes of error in VBA programs, but many text books provide little guidance on this subject, and what there is, is … Continue reading
Hello World (again)
Over at Daily Dose of Excel Dick has been asking for suggestions for excellent training, to which Jan Karel Pietersen replied that training should be relevant to the task at hand, and that “hello world” examples are useless. John Walkenbach responded … Continue reading
Good practice, best practice, or just practice?
Browsing the ‘net this morning I found the “Golden Rules” listed below at Ozgrid.com The rules are described as things that “should not be optional”, which seemed to me in some cases to be going way too far, since for many … Continue reading
Perfect Anniversaries
The young author of The Math Less Travelled has just celebrated his 28 birthday, noting that 28 is a perfect number. He laments that since the next perfect number is 496, it is most unlikely that he will see another perfect … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Anniversaries, Perefect numbers, UDF, VBA
Leave a comment
Frame4.xls – Update2
It was recently pointed out to me that the Frame4 spreadsheet was giving an overflow error with a fairly small analysis. The problem turned out to be that the analysis did not have any restraint specified in the X direction, … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Finite Element Analysis, Frame Analysis, VBA
12 Comments
