excel9

Now choose to insert a module (a module is like a sheet of paper on which you write your macros):

Now type in the following in the blank screen which appears:

Sub EnterName()

'go to the top left cell and type your nameRange("A1").SelectActiveCell.Value = "Bob"

End Sub

Position your mouse pointer somewhere within this macro and press the F5 function key. When you have a look at your worksheet, you should see your name (or at least Bob’s) in cell A1!

This article was provided by Andy Brown, director at Wise Owl Training. The organisation provides computer training for businesses and individuals. He hopes that this has given you sufficient motivation to explore Excel further!