Offset (1,1)

[gheyman]

On sheet Worksheet change I want to find the last row in my table and offset by one row and one column and put the words "Enter new category here"

Any help is a appreciated

Private Sub Worksheet_Change(ByVal Target As Range)

Dim LR As Long

    LR = Cells(Rows.Count, "C").End(xlUp).Row
    
    LR.Offset(1, 1).Select
    
    ActiveCell.Value = "< Enter new Catagory Here"

End Sub

 

[Joe4]

Try:

Private Sub Worksheet_Change(ByVal Target As Range)

    Dim LR As Long

    LR = Cells(Rows.Count, "C").End(xlUp).Row
 
    Application.EnableEvents = False
    Cells(lr + 1, "D").Value = "< Enter new Catagory Here"
    Application.EnableEvents = True

End Sub

Note: I used column "D", because one column offset form column "C" is column "D".
Not sure if that is what you intended, it is hard to tell from your post.

 

[gheyman]

Thanks Joe!

 

[Joe4]

You are welcome.

Note the edits I made to my original reply.
I initially didn't notice that you wanted to offset one column in addition to one row.