Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here is the code I'm using in an existing macro to keep only rows with
today's date in column F, however it is deleting all rows. My date format in the column is MM/DD/YYYY. Any help you can provide is appreciated. Thanks Joyce Keep only rows dated today 'Dim LastRow As Long 'Dim RowNdx As Long ' LastRow = Cells(Rows.Count, "F").End(xlUp).Row ' For RowNdx = LastRow To 1 Step -1 ' If StrComp(Cells(RowNdx, "F"), "=today", vbTextCompare) < 0 Then ' Rows(RowNdx).Delete ' End If ' Next RowNdx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting rows in two columns with a code in visual basic | Excel Discussion (Misc queries) | |||
Deleting rows based upon Error conditions | Excel Programming | |||
Help with Chip Pearson's Code for Deleting Blank Rows | Excel Programming | |||
VBA code for Deleting rows by verification | Excel Programming | |||
visual basic macro code for deleting referenced rows | Excel Programming |