Find last used row in a column and offset by 2 columns

[Eric12]

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.

If Sheets("Sheet1").Range("N7") = "" Then
    Sheets("Sheet1").Range("N7") = myValue1
Else
    Sheets("Sheet1").Range("N33").End(xlUp).Offset(1) = myValue1
End If

 

[Eric12]

Sorry thread name should be but I'm not sure how to edit.
[h=1]Find last used row in a column and offset to a different column.[/h]

 

[Fluff]

Try

Sheets("Sheet1").Range("A34").End(xlUp).Offset(1, 13) = myValue1

 

[Eric12]

This worked perfectly. Thank you.

 

[Fluff]

Glad to help & thanks for the feedback