dimanche 19 avril 2015

runtime error while using variables in VBA

i am new to VBA.

this simple line of code i throwing up error as Application or Object defined error.

Sub vartest()
movie_name = "TITANIC"

Range("b1").End(xlDown).Offset(1, 0).Select
Active.Value = movie_name
MsgBox movie_name & " is the Movie"

please help.

regards Kairav

Aucun commentaire:

Enregistrer un commentaire