| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Delete rows within a date range
Hi I'm new to vba programming, here is my problem. I have 2 variable
one named start_date and the other end_date. What I am trying to do i go through a worksheet and look at a cell in each row called startdat and compare it to the dates that were entered into the variables above If the date in the cell in each row is not = to the start_dat variable and is not <= the end_date variable then I want to delete tha entire row. Basically if the date in the cell is not within the dat range of the two variables, then that row needs to be deleted. It needs to go through the whole worksheet to eliminate all rows wit dates that don't fall within this range. Can someone please help I am desperate. Thank -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Count is not in a certain range, delete Rows | Excel Discussion (Misc queries) | |||
| Select a range of rows to delete | Excel Worksheet Functions | |||
| Delete rows based upon a range of times | Excel Discussion (Misc queries) | |||
| Macro to delete blank rows in a data range | Excel Discussion (Misc queries) | |||
| delete rows in range - macro | Excel Worksheet Functions | |||
Threaded Mode
