Debugging that way from the Immediate window can be terribly painful.
From the View menu choose Locals Window then expand arrwords.
Another way is to go View | Watch Window
Then from the Debug menu, Add Watch
The expression would be arrwords
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"Hari Prasadh" wrote in message
...
Hi,
Im in the middle of executing code. I have put a break point just after
the code has Read through the values in an Array called - arrwords.
I wanted to check whether the reading of array has been done properly, so
opened up the immediate window (Ctrl + G)
and wrote the following as it is (Stole from Chip's site)
? For N= LBound(arrWords) To UBound(arrWords): Debug.Print arrWords(N) :
Next N
I get a -- compile error : expected expression
But if i read through the array element by element then I dont get any
error.
? arrwords(4)
microsoft
? arrwords(3)
basic
? arrwords(2)
visual
? arrwords(1)
objects
? arrwords(0)
net
What am I doing wrong in the method of combining several lines of code in
to one single line of code.
Thanks a lot,
Hari
India