Thread: Find in a range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd huttenstine Todd huttenstine is offline
external usenet poster
 
Posts: 260
Default Find in a range

Hey guys

I need a code that will simply return true or false if a
value is found in a range.

Range C:C contains a list of values. Range A:A also
contains a list of values. What is a code that will look
at each value in range A:A and determine wheather or not
its in Range C:C. If the value is detected in range C:C
then do nothing. If the value is NOT detected in range
C:C then add it to the range at the bottom.


What is the code for this?

Thank you
Todd Huttenstine