ya_Muntaqim
03-07-2013, 01:47 AM
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..:banghead:
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!
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..:banghead:
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!