Hi Thomas
Possibilities:
1 The spreadsheet is protected
2 The cells are entered as text while the other cells are numbers
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of Thomas Goff
Sent: Thursday, 7 July 2011 10:22 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Filter function not working correctly in Excel 2010
Hi all,
I am working on a excel workbook, and I am attempting to use the filter
function. I have 1453 rows, and 23 columns own are never filtered out,
regard less of what try to filter out. I have tried Ctrl a and then appling
the filter, and it still isn't working. Any ideas of what might be causing
this? I don't have any macros in the workbook.
Thanks!
------------------------------------
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------Yahoo! Groups Links
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar