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



--

Do a Find and Replace in Excel (Ctrl-H) with the macro recorder on. There's
your code.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ben" wrote in message
...
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



--