Filter to show top 5 items

[kenadams378]

In my code to filter on some data i'm trying to filter out the top 5 highest values.

My code

Please Login or Register  to view this content.

The code just fails to run properly.

Any ideas?

[pareshj]

Hi,

Try this following code, its untested but hope it works.

Please Login or Register  to view this content.

Note : Make necessary changes in the above code as per your requirement.

Regards,
Paresh J

[Richard Buttrey]

Hi,

Why use VBA when the standard autofilter allows you to filter the top x values?

[kenadams378]

I want the process to run so the user just needs to verify the data rather than produce it.

[kenadams378]

Hi,

I need to change this slightly so that the filter will only show items above 250,000.00?