Application defind or object defind error

See more:

macros

VBA

error-handling

I am learning VBA macros from the available videos over internet.When i am trying to execute the program,this particular statement is throwing the error -- "Range("A2").End(xlDown).Offset(1, 0).Value = Film_Name".But in the video is executed properly.Please help me with the issue

Sub generic()
Dim Film_Name As String
Dim Film_Date As Date
Dim Film_length As Integer

Film_Name = InputBox("Enter a film name")
Film_Date = InputBox("Enter a Date")
Film_length=Inputbox("Please enter the length of the film")
Range("A2").End(xlDown).Offset(1, 0).Value = Film_Name
Range("A2").End(xlDown).Offset(0, 1).Value = Film_Date
Range("A2").End(xlDown).Offset(0, 2).Value = Film_length

End Sub

What I have tried:

I have no clue what is wrong with the statement.Syntax is same as showed in the video.