Generally it is useful to repeat actions.

As a start, go to Tools=Macro, Record a New macro.

then perform some actions on the worksheet. then hit the stop recording
button, or if it is not visible, go into Tools=Macro, Stop Recording


Now go to tools=Macro=Macros, select your recorded macro and click the run
button. It should repeat the actions you just performed.
--
Regards,
Tom Ogilvy

"Mohamed" wrote in message
...
How do i use coding?