Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Date Macro
Any ideas about how to create a code so that every time the word Date
appears in a cell in column A, the row that Date exists in will be deleted? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Date Macro
Sub DeleteDateInA()
FirstRow = 2 'Headings in row 1 LastRow = Range("A" & Rows.Count).End(xlUp).Row For r = LastRow To FirstRow Step -1 If Range("A" & r).Value = "Date" Then ' Date is the only word in the cell 'If Range("A" & r).Value like "*Date*" Then ' * Allow text before and after Date Rows(r).Delete End If Next End Sub Hopes this helps --- Regards, Per "Workbook" skrev i meddelelsen ... Any ideas about how to create a code so that every time the word Date appears in a cell in column A, the row that Date exists in will be deleted? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to delete rows based on date | Excel Discussion (Misc queries) | |||
Macro to delete space in front of date | Excel Programming | |||
Delete Date data macro | Excel Programming | |||
macro to find date format in a cell and delete that entire row | Excel Programming | |||
Macro want delete the date row? | Excel Programming |