Visual Basic Macro problem

I’m trying to record a simple macro in Excel 97. I want the macro to start where the cursor is at the moment in the current spreadsheet. Currently, the marco jumps to the cell I created the macro in. This macro will be used in several files.