Doing MS Training in Excel, having Macro Issue
Judi;
As I noted, the declaration is the "Dim" statement.
The "As" portion tells Excel what the format is.
Try
Dim MyCell as Variant
--
Regards
Rob
"Judi<<" wrote in message
...
Now I have this one. I defined z as long, but VBA is telling me that MyCell
needs to be defined too, how do you define a cell?
Thanks again,
Judi <<
Option Explicit
Sub CountCells()
Dim z As Long
z = 0
For Each MyCell In Selection
z = z + 1
Next
MsgBox "There are " & z & " cells in the selection."
End Sub
|