Hello all. This is probably a simple one that I am just having problems figuring out because I am still learning VBA. But I am trying to loop through a column (Q) and replace any values that are Text with the current time and leave any numeric cells alone from rows 2 to 3000. I've tried every way I can think of from complex functions to the simplest I can and it either stops once the first value is replaced or just plain does not work at all. The latest thing (and simplest way I could think of) I've tried stops once the first value is replaced (Below). Any help is greatly appreciated.
Code:
Sub GP_Click()
Dim i As Integer
ThisWorkbook.Sheets("Performance Log").Select
i = 2
Do While i < 3000
If Application.WorksheetFunction.IsText(ActiveCell.Value) Then
Cells(i, 17).Value = Now
End If
i = i + 1
Loop
End Sub