View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
malik641[_9_] malik641[_9_] is offline
external usenet poster
 
Posts: 1
Default Search Text in Comments


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