Could not get Column property,Invalid argument

i added the first bit of code to the code below as demonstrated and now i get topic error

findvalue.Offset(0, 3).Value = Me.Txt_OTRate.Value
findvalue.Offset(0, 2).Value = Me.Txt_OTAfter.Value

findvalue.Offset(0, 3).Value = Me.Txt_OTRate.Value
findvalue.Offset(0, 2).Value = Me.Txt_OTAfter.Value
findvalue.Offset(0, -1).Value = Me.txt_Notes.Value             '*****this is the col just before ID
findvalue.Offset(0, -2).Value = Me.Txt_NoRate.Value
findvalue.Offset(0, -3).Value = Me.Txt_SunNR.Value
findvalue.Offset(0, -4).Value = Me.Txt_SunDR.Value
findvalue.Offset(0, -5).Value = Me.Txt_SNR.Value
findvalue.Offset(0, -6).Value = Me.Txt_Mobile_Number.Value
findvalue.Offset(0, -7).Value = Me.Txt_Con_Number.Value
findvalue.Offset(0, -8).Value = Me.Txt_Con_PostCode.Value
findvalue.Offset(0, -9).Value = Me.Txt_Con_Addy_Twn.Value
findvalue.Offset(0, -10).Value = Me.Txt_Con_Addy_St.Value
findvalue.Offset(0, -11).Value = Me.Txt_Contract_Name.Value
findvalue.Offset(0, -12).Value = Me.Txt_Agency.Value             '*****this is your first col
Call MsgBox("The Contract has been updated", vbInformation, "Edit Contract")

0 is where my ID is. any suggestions please

this is the whole code to my edit button as it sits right now

Private Sub cmdEdit_Click()
'error handler
On Error GoTo cmdEdit_Click_Error
'check that there is data to edit
If Me.txt_Notes = "" Then
Call MsgBox("The fields are not complete", vbInformation, "Edit Contract") '*****Change Contact to file name
Exit Sub
End If
'find the value in case of duplicates we use an ID
Sheet6.Range("a1") = txtID.Value
Set findvalue = Sheet6.Range("N8:N10000").Find(What:=Me.txtID, LookIn:=xlValues)
'findvalue.Value = Me.txtID "we do not want to edit the ID"
'*****These names go in reverse from last col to first*****
findvalue.Offset(0, 3).Value = Me.Txt_OTRate.Value
findvalue.Offset(0, 2).Value = Me.Txt_OTAfter.Value
findvalue.Offset(0, -1).Value = Me.txt_Notes.Value             '*****this is the col just before ID
findvalue.Offset(0, -2).Value = Me.Txt_NoRate.Value
findvalue.Offset(0, -3).Value = Me.Txt_SunNR.Value
findvalue.Offset(0, -4).Value = Me.Txt_SunDR.Value
findvalue.Offset(0, -5).Value = Me.Txt_SNR.Value
findvalue.Offset(0, -6).Value = Me.Txt_Mobile_Number.Value
findvalue.Offset(0, -7).Value = Me.Txt_Con_Number.Value
findvalue.Offset(0, -8).Value = Me.Txt_Con_PostCode.Value
findvalue.Offset(0, -9).Value = Me.Txt_Con_Addy_Twn.Value
findvalue.Offset(0, -10).Value = Me.Txt_Con_Addy_St.Value
findvalue.Offset(0, -11).Value = Me.Txt_Contract_Name.Value
findvalue.Offset(0, -12).Value = Me.Txt_Agency.Value             '*****this is your first col
Call MsgBox("The Contract has been updated", vbInformation, "Edit Contract")

'reset error
On Error GoTo 0
Exit Sub
'if error occurs then show me exactly where the error occurs
cmdEdit_Click_Error:
MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure cmdEdit_Click of Form Contract"
End Sub

Originally Posted by shg

What line errors with what message?

It comes up with my userform. Ive plenty of columns.

Originally Posted by shg

What line of code fails, with what error message?

i gave up and redesigned my worksheet (not tested yet but should work)