ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto Filter Problem (was VBA help) (https://www.excelbanter.com/excel-discussion-misc-queries/102209-auto-filter-problem-vba-help.html)

Rich

Auto Filter Problem (was VBA help)
 
Hi,

I previously asked for VBA help but have notice the the problem exists
without the macro, when I do the task manually.

Column G contains a list of numbers. When I try to autofilter the top 15%,
nothing happens.

It works fine for columns A to F. But G and beyond, auto filtering by top10
doesn't work. The menu appears and I can key in values, but no effect.

Any ideas ?



Dave Peterson

Auto Filter Problem (was VBA help)
 
You've got some nice replies at your other thread.

Rich wrote:

Hi,

I previously asked for VBA help but have notice the the problem exists
without the macro, when I do the task manually.

Column G contains a list of numbers. When I try to autofilter the top 15%,
nothing happens.

It works fine for columns A to F. But G and beyond, auto filtering by top10
doesn't work. The menu appears and I can key in values, but no effect.

Any ideas ?


--

Dave Peterson


All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com