Hi all,

I have a spreadsheet in Excel XP format. It has 16000 rows. Currently I
step through every row to look to look at the data in column K and replace it
with a new value through a select case statement:

if x then new value is 1
if y then new value is 2
....
....
etc

This process takes about 2+ mins over a network connection. However, I am
wondering if there's a better more efficient way of doing look up and replace
cell value. Thanks.

Ben



--