I want to create a formating Macro in Excel97 that will activate in relation to the current active cell, rather than the cell that was active at the time the Macro was created. It must be simple, but every time I create it, the Macro goes back to the specific cells rather than cell relative to the new start point.
Any assistyance greatfully received.
Regards
Graham