I am running the following code and for some reason it is finding the 1st empty cell in a completely different range. For example, it goes to the 1st empty cell in the "AA19:AA24" range. I just ran it and it went to cell "AA20" because AA19 already had a value in it and every cell in the "AA11:AA17" range was empty. I'm sure it is something simple that I am missing but I just can't figure it out. Any ideas?
Code
Sub LookatU6()
'
' Macro1 Macro
'
Dim wksht1 As Worksheet
Dim u6 As Range
Set wksht1 = Worksheets("Nucomat_Dashboard")
Set u6 = wksht1.Range("AA11:AA19").Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Offset(1, 0)
On Error Resume Next
With Sheets("Nucomat_Dashboard")
If Range("N14").Value = 0 Then
u6.Value = Now()
End If
End With
End Sub
Display More