Tom, Thanks for the help. However, I'm still having problems. First
I haven't quite figured what each line of code or code statement i
doing. My bad I'm sure. Second, when I tried to run the procedure
got a Compile error Variable not defined res=
I tried to Dim res as Range and got Object variable or Withbloc
variable not set
I tried to Dim res as Long and got Run-time error '13': Type mismatch
I'm trying to get everything I can out of Sams, "Teach Yoursel
Microsoft Excel 2000 Programming in 24 Hours." It's slow going and m
smarts aren't yet up to the answer you were nice enough to give me.
Could I prevail upon you a little further

--
knowtrum
-----------------------------------------------------------------------
knowtrump's Profile: http://www.excelforum.com/member.php...fo&userid=1966
View this thread: http://www.excelforum.com/showthread.php?threadid=50610