The TFE and variant variable experiment.

  1. Turn in the printout of your VBA code and a table showing the 5 different times for execution (TFE). Note that TFEs will vary depending on what computer you run the program. Older computers with slower memory and/or slower CPUs will obviously have different times for execution than newer computers. With the table of 5 times, discuss why the times vary so much by utilizing lecture notes from Thursday, September 23rd and your understanding of the Dim statement and Variant variables.