maybe try this version
Sub sbDelete_Rows _Date() Dim lRow As Long Dim iCntr As Long lRow = 10000 For iCntr = lRow To 12 Step -1 If Cells(iCntr, 21) = Today() Then Rows(iCntr).Delete End If Next End Sub
maybe try this version
Sub sbDelete_Rows _Date() Dim lRow As Long Dim iCntr As Long lRow = 10000 For iCntr = lRow To 12 Step -1 If Cells(iCntr, 21) = Today() Then Rows(iCntr).Delete End If Next End Sub
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link