Jef Gorbach
12/16/2006 6:47:00 AM
presume this is part of a larger macro?
select case range("A1").value
case 1000: range("c4").value=range("a1").value
case 25000:range("c5").value=range("a1").value
case 100000:range("c6").value=range("a1").value
end case
"walt" <walt@discussions.microsoft.com> wrote in message
news:9E0F4E9B-A23A-4DC1-985E-F97E2007EC4E@microsoft.com...
> I would like to send certian range numbers to a specific cell from a
single
> cell such as
>
> you would enter the number in a1
> if the number is 501-1000 it would go yo c4
> if the number is 1001-25000 it would go yo c5
> if the number is 25001-100000 it would go yo c6
>
> and so on