Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please help VBA code not working properly send email when due dates | Excel Worksheet Functions | |||
selecting the first date in a range of dates | Excel Worksheet Functions | |||
Dates don't appear properly after downloading data from Accounting | Excel Discussion (Misc queries) | |||
OR(EXACT(Cell; Range)) does not work properly | Excel Worksheet Functions | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) |