Change Value Sub procedure not working!!!! :(

[SebastianColombia]

Hello to everyone. First of all, good morning/afternoon/evening. I'm just starting with VBA and I know very little about this matter, I;m reading Excel Visual Basic Programming by John Walkenbach, a really nice book.

I'm trying to make this macro work, but I don't know what I can be doing wrong. Every time I run the code a Run-Time Error '9' appears. . I would really appreciate if you can help me.

Code
Sub ChangeValue()
Worksheets(“Sheet1”).Range(“a1”).Value = 994.92
End Sub

Thanks!!!

 

[FormR]

Welcome to the forum.

Your double quotes do not look right - did you copy and paste them from somewhere?

Try:

Sub ChangeValue()
Worksheets("Sheet1").Range("a1").Value = 994.92
End Sub

 

[SebastianColombia]

Yes Sir!!!! all the problem were the double quotes!!.

Thank you very much sir!!!