LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Dates in range not selecting properly

I want to select lines containing a range of dates from a series of
worksheets and to paste these lines into another "Results" worksheet. The
sub works well, except that the date selection picks dates outside my range.
With datestart = 1 Jan 2006, and dateend = 31 Dec 2006, the following
program picks all dates ('datews') within this range, but also gets some
outside it.

'Dim datestart As Date, dateend As Date, datews As Date
'If datews = datestart And datews <= dateend Then
'.....
'End if

Any ideas?
Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help VBA code not working properly send email when due dates Tia[_3_] Excel Worksheet Functions 0 July 21st 09 08:37 AM
selecting the first date in a range of dates shoun2me Excel Worksheet Functions 7 August 8th 07 07:02 PM
Dates don't appear properly after downloading data from Accounting r Excel Discussion (Misc queries) 4 June 15th 07 10:18 AM
OR(EXACT(Cell; Range)) does not work properly Dave Peterson Excel Worksheet Functions 4 January 1st 07 03:11 AM
Excel not recognizing Dates properly. Dan Excel Discussion (Misc queries) 1 March 23rd 05 07:19 PM


All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"