I'm trying to write code that finds the row value of a cell with a certain value from a combobox1 and then insert other data into the columns next to it. I have this code so far and it comes up with an error saying 'run time error 13- type mismatch) I've put an arrow next to where it highlights this error..

Private Sub BookButton_Click()
Dim c As Variant

Dim datev As String

Dim r As Variant
datev = ComboBox1.value
c = Application.Match(datev, Worksheets("Calender").Range("A:A"), 0)
     With Worksheets("Calender").Range("A:A")
 
  .Offset(c, 3).value = HostsName.value
   End With
End Sub