Select Case Options

[Jody]

Hi,
Apart from making really long hard to read If statements, are they any
options open to me?
I do not use excel a lot, so i may be missing something obvious.
I was thinking the code could be made into a custom sub/macro, but not sure
if that's the way to go.

Any advice?

Thanks!
jody'

i want c cells contents to be based on the b cell as below

for b1... -> 1000
select case row.column
case 30 to 40
row.column+1 = 300,000
case 41 to 50
row.column+1= 500,000
case 51 to 60
row.column+1= 700,000
case 61 to 70
row.column+1= 700,000+ rand()*500,000
....
case 200 to 250
row.column+1= 10,000,000 + rand()*5,000,000
end select
next

[Bob Phillips]

What are you trying to achieve? Do you want to loop though a range of cells
in column B, and set B according to its value? I so, could you explain it in
English?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jody" <[email protected]> wrote in message
news:[email protected]...
> Hi,
> Apart from making really long hard to read If statements, are they any
> options open to me?
> I do not use excel a lot, so i may be missing something obvious.
> I was thinking the code could be made into a custom sub/macro, but not
sure
> if that's the way to go.
>
> Any advice?
>
> Thanks!
> jody'
>
> i want c cells contents to be based on the b cell as below
>
> for b1... -> 1000
> select case row.column
> case 30 to 40
> row.column+1 = 300,000
> case 41 to 50
> row.column+1= 500,000
> case 51 to 60
> row.column+1= 700,000
> case 61 to 70
> row.column+1= 700,000+ rand()*500,000
> ...
> case 200 to 250
> row.column+1= 10,000,000 + rand()*5,000,000
> end select
> next
>
>