hello,
I need help with one issue (I uploaded excel worksheet with data) and I need this :
if in column A in some row is text "today" then delete this row and delete all rows until in row B wont be empty cell
I have start (If in A is "Today" then ... ) but thas's all
anyone who could help? THANKS !![]()
Sub delete() Dim lngRow As Long lngRow = 1 For lngRow = 1 To 24 If Range("A" & lngRow) = "Today" Then End If Next End Sub
![]()
Bookmarks