ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Autoselect problem (https://www.excelbanter.com/excel-programming/287859-vba-autoselect-problem.html)

godgo

VBA Autoselect problem
 
Can anyone help me explain why the following code does not work. It appears
to be a bug in Excel 2003.

This is a simple spreadsheet that contains a command button that calls a one
line piece of vba code to do an autofilter on a range of dates. When the
line is executed, it returns no data, however if you manually go into the
autofilter drop down the values are there and a simple OK to the dialogue
box will return the correct results.

Am I missing something?







Andy

VBA Autoselect problem
 
Am I missing something?

Adding the code to your post ;-)

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

"godgo" <godgo@godgo wrote in message
u...
Can anyone help me explain why the following code does not work. It

appears
to be a bug in Excel 2003.

This is a simple spreadsheet that contains a command button that calls a

one
line piece of vba code to do an autofilter on a range of dates. When the
line is executed, it returns no data, however if you manually go into the
autofilter drop down the values are there and a simple OK to the dialogue
box will return the correct results.

Am I missing something?










All times are GMT +1. The time now is 12:39 PM.

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