excel01noob
Board Regular
- Joined
- Aug 5, 2019
- Messages
- 93
- Office Version
- 365
- 2016
Hi
I have this sub-procedure created.
As we export some date into excel and that data always have a row at the end with "query executed timestamp" I want to be able to manipulate the date after.
the below works if I have the "query" word in the data but how do I tell the sub to continue to other procedures if that word is not present ?
Sub word_query()
Dim queryword As String
queryword = "query"
If Cells.Find(What:=queryword).Activate Then
ActiveCell.EntireRow.Select
Selection.Delete
End If
Cells.EntireColumn.AutoFit
Range("A1").Select
End Sub
I have this sub-procedure created.
As we export some date into excel and that data always have a row at the end with "query executed timestamp" I want to be able to manipulate the date after.
the below works if I have the "query" word in the data but how do I tell the sub to continue to other procedures if that word is not present ?
Sub word_query()
Dim queryword As String
queryword = "query"
If Cells.Find(What:=queryword).Activate Then
ActiveCell.EntireRow.Select
Selection.Delete
End If
Cells.EntireColumn.AutoFit
Range("A1").Select
End Sub