Nikki,
Here's is a trick you can use to find out anything you want to know about Excel.
Go to Excel, load it, choose tools/macros/record macro. Then do what you want and then stop recording. Use tools/marcos edit the macro you just recorded and read the code.