Well I have just tried the sample data and it worked fine.

It might be copying the data from the web that is a problem. Try this data
with Dave's original macro.

Bh72 R.sol A.tum EbN1 N.euro G.metali
PF00013 PF00013 PF00013 PF00013 PF00013 PF00013
PF00015 PF00015 PF00015 PF00015 PF00015 PF00014
PF00023 PF00023 PF00023 PF00023 PF00016 PF00015
PF00027 PF00027 PF00024 PF00027 PF00023 PF00023
PF00028 PF00032 PF00027 PF00032 PF00027 PF00027
PF00032 PF00033 PF00032 PF00033 PF00032 PF00032
PF00033 PF00034 PF00033 PF00034 PF00033 PF00033
PF00034 PF00035 PF00034 PF00035 PF00034 PF00034
PF00035 PF00036 PF00035 PF00036 PF00035 PF00035

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

wrote in message
oups.com...
I'm using the sample data. After running the macro the results are as
follows:

Bh72 R.sol A.tum EbN1 N.euro G.metali

PF00013 PF00013 PF00013 PF00013 PF00013 PF00013
PF00015 PF00015 PF00015 PF00015 PF00015 PF00014
PF00023 PF00023 PF00023 PF00023 PF00016 PF00015
PF00027 PF00027 PF00024 PF00027 PF00023 PF00023
PF00028 PF00032 PF00027 PF00032 PF00027 PF00027
PF00032 PF00033 PF00032 PF00033 PF00032 PF00032
PF00033 PF00034 PF00033 PF00034 PF00033 PF00033
PF00034 PF00035 PF00034 PF00035 PF00034 PF00034
PF00035 PF00036 PF00035 PF00036 PF00035 PF00035