I need some help with the code below. In column "A" I put in the date of a report I'm doing between ranges "A7:A33". I have a macro that looks for a certain value and it puts it in the next available row in column "N". On instances that the value is not found the cell will stay empty. What I'm trying to do is instead of inserting the value in the next available cell in column "N" I would like to find the last used row in range "A7:A33" and offset to column "N" to insert value.
Code:
If Sheets("Sheet1").Range("N7") = "" Then
Sheets("Sheet1").Range("N7") = myValue1
Else
Sheets("Sheet1").Range("N33").End(xlUp).Offset(1) = myValue1
End If