if you press F1 (for help) and type in MACRO you will get info for all you need to know about recording a macro and executing it either directly or by creating a button on the worksheet which you can click to execute and a whole lot more info besides.
that should sort you out initially and having done that if you still have a problem come back and we can help further
-- Posted: 2005-05-17 11:33:07 Edit :
Quote