I haven't try it yet, but give it a try
![]()
Sub test() Do Cells.Find("1900/01/01", , xlValues, xlPart).EntireRow.Delete Loop Until WorksheetFunction.CountIf(Cells, "1900/01/01") = 0 End Sub
I haven't try it yet, but give it a try
![]()
Sub test() Do Cells.Find("1900/01/01", , xlValues, xlPart).EntireRow.Delete Loop Until WorksheetFunction.CountIf(Cells, "1900/01/01") = 0 End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks