why not just use (record and cleanup)
datafilterautofiltertop 10etc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nick" wrote in message
...
Hello

Please help.

I'm trying to program Excel to run down a column of values, taking the top
10 highest values and populating another worksheet with the adjacent
reference for these values.

For example

If I have company registration numbers in one column and their
corresponding
credit risk ratings in another column, I want excel to populate another
worksheet with the registration numbers of the top 10 most risky companies
.

I can do this manually, but I want add a button so that my colleagues can
perform the same action with exactly the same result.

Any hints would be much appreciated and I would be willing to make a
donation

Many thanks in advance, Nick