I guess that you don't mean

[vba]Range("A1").Value = 5[/vba]