The easiest way to see how to do things is to use the macro recorder.
This will generate a macro for you with all the relevant properties and
methods.
You can then use this as a base to write fully functional code that
accepts parameters and all the other bells and whistles you can put in
yourself (A good bookm on VBA would help).
To access the recorder, use -Tools-Macro-Record New Macro-. To
access the
Vb editor to see the monster you've created use
-Tools-Macro-
VB Editor-.
Regards
Rich
--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile:
http://www.excelforum.com/member.php...o&userid=24737
View this thread:
http://www.excelforum.com/showthread...hreadid=383159