Macro Stepping

[George]

When stepping through a macro where values are being changed ( e.g.as in a
loop) is it possible to "see" the current values.

For Example :-

For x= 1 to 19
For y = x+1 to 20
If Cells(x,2) = Cells (y,2) Then ' do something'
next y
next x

I would like to be able to see the values of x & y in the VBA pane as I step
through th macro.

Reagrds
George

[Norman Jones]

Hi George,

Try using the Locals Window to see all variables. Alternatively, open the
Watch Window and add thr required variables or expressions.

Either window may be opened from the View menu.


---
Regards,
Norman


"George" <nz@mbeb.co.za> wrote in message
news:e7g5jm$ph7$1@ctb-nnrp2.saix.net...
> When stepping through a macro where values are being changed ( e.g.as in a
> loop) is it possible to "see" the current values.
>
> For Example :-
>
> For x= 1 to 19
> For y = x+1 to 20
> If Cells(x,2) = Cells (y,2) Then ' do something'
> next y
> next x
>
> I would like to be able to see the values of x & y in the VBA pane as I
> step through th macro.
>
> Reagrds
> George
>
>
>

[Andrew Taylor]

If you hover your mouse pointer over the variable name you'll see the
value displayed.



George wrote:
> When stepping through a macro where values are being changed ( e.g.as in a
> loop) is it possible to "see" the current values.
>
> For Example :-
>
> For x= 1 to 19
> For y = x+1 to 20
> If Cells(x,2) = Cells (y,2) Then ' do something'
> next y
> next x
>
> I would like to be able to see the values of x & y in the VBA pane as I step
> through th macro.
>
> Reagrds
> George

[NickHK]

George,
As well as the other replies, you can print to the Immediate window. e.g.
Debug.Print "x=" & x, "y= & y

NickHK

"George" <nz@mbeb.co.za> wrote in message
news:e7g5jm$ph7$1@ctb-nnrp2.saix.net...
> When stepping through a macro where values are being changed ( e.g.as in a
> loop) is it possible to "see" the current values.
>
> For Example :-
>
> For x= 1 to 19
> For y = x+1 to 20
> If Cells(x,2) = Cells (y,2) Then ' do something'
> next y
> next x
>
> I would like to be able to see the values of x & y in the VBA pane as I
step
> through th macro.
>
> Reagrds
> George
>
>
>