Dave,
THANKS! That works great!!! Perfect!!
I just have ONE MORE question...
Instead of having the range be specific (i.e. C4:C44). How do I make it
so that you select a certain amount of cells, and then place the answer
a certain amount of cells lower than my last selected cell in the
column (selected cells will only be one column wide but many rows
down). Here's an example:
Cells C4:C44 are selected
Answer will be 32 spaces below C44 (C76).
This will be the LAST thing I promise (well, I hope anyway)
--
malik641
------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread:
http://www.excelforum.com/showthread...hreadid=386198