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"
Worksheets("Sheet1").Activate

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