thanks for the help.

the macro listed above works fine. thanks

how exactly do you add a hotkey command to a macro?
(i've only ever made macros with hotkeys through the recorder, not via
writing the code from scratch)


--
joncraver
------------------------------------------------------------------------
joncraver's Profile: http://www.excelforum.com/member.php...o&userid=34390
View this thread: http://www.excelforum.com/showthread...hreadid=541707