Week 8, starting Monday 20th November
All work should be completed in the session for which it is set. Work carried over for marking in the following week will only receive half the credit. Note that the session ends at 5:30pm, and work should be marked by this time. Please get each exercise marked as you finish it.
This week you should complete the following tasks:
In last week's exercises you used the keystroke recording facilty in Excel to construct the code in your macros. There are many more times when you need to write code to achieve tasks that cannot be done simply by recording your keystrokes. The remaining exercises are of this type.
You begin, in VBA task 3, by writing some Function procedures to carry out three-dimensional vector operations, such as scalar product, vector product and magnitude.
Then we make use of these procedures written to solve two problems presented in VBA task 4.