Sorryl my Question was cross posted to these forums:

http://www.mrexcel.com/forum/showthread.php?t=378477
http://bytes.com/topic/visual-basic/...67106-vb-excel

VBA Noob, is this how to do this?