Doing MS Training in Excel, having Macro Issue
Judi;
Not that this is much of an answer but I copied your code directly and it works perfectly for me
(Excel '03 on Xp).
Try adding these statements to the beginning of the module (before the "Sub" statement).
Dim x as long
Dim y as integer
Dim z as long
Sounds like you options are set to "Require Variable Declaration" (Tools-Options-Editor-Code
Settings")
This means that any variable you use must be declared (done via "Dim" statement).
HTH
--
Regards
Rob
"Judi<<" wrote in message
...
I am trying to work through the online training provided by Microsoft about
Excel 2003 and I have run into an issue with the Macro lesson.
Following the instructions exactly, I have entered this macro in to a module
in the spreadsheet:
Sub CountRows()
x = ActiveCell.Row
y = ActiveCell.Column
z = 0
Do While Cells(x, y).Value < ""
x = x + 1
z = z + 1
Loop
MsgBox "There are " & z & " rows in the current range."
End Sub
When I try to run the macro, it tell me that variable x is undefined. I
tried going into the spreadsheet and placing the focus where they said and
running it from there, but I get the same message.
Please help me understand what I need to do to fix this. I am doing the
training so that I can understand this, but if the training is wrong, how am
I supposed to learn?
Feel free to talk to me like a child, I'm completely new to VBA.
Thank you to all who offer help.
|