Hi all,
I am new here and I am a newbie with VBA. These are just my first steps.

I have met this sort of problem while trying to go through VBA for Dummies lessons..

Sub ShowValue()
Contents = Worksheets(“Sheet1”).Range(“A1”).Value
MsgBox Contents
End Sub


This should be sooo easy according to the book, but I can't move on with the material because of the error 9 "Subscription ouf of range".

What's the problem. Pls help me, or I will go mad...

I am using excel 2007 btw.

thanks in advance for your answers!