Re: Macro Stepping

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: Independent thread fireing events in ATL Service synchronization requirements?
    ... and hence the loop will not execute, ... m_vec itself is not a pointer, so it cannot be NULL for sure. ... >> Did you lock while adding and removing your objects to the list? ... >>> and made my client list a class with synchronization inside ...
    (microsoft.public.vc.atl)
  • Faster 32-bit mul for IAR 78K0 3.34B
    ... Browsed couple days ago throuh the IAR 78K0 C 3.34B libraries and was somehow disapointed to notice that the the 32 bit multiplication was a 'traditional' one, i.e. one that does not use the microcontroller's own multiply instruction. ... ; On the outer loop the 'result' and 'right' bytes are processed; at the same rate, so the hl pointer and pointer + fixed offset; can be used to access a byte from both of the variables. ...
    (comp.arch.embedded)
  • Re: Threading problem
    ... Note that if you manage to delete the form while this loop is running, ... but if this is a pointer to free storage on the ... and close the form when the reference ... the thread instead of relying on the GetSafeHwnd() call. ...
    (microsoft.public.vc.mfc)
  • Re: [PATCH] fix/improve generic page table walker
    ... caused by the unconditional loop over all pgd/pud entries as specified ... Which means that the pgd and/or the ... pud pointer can get out-of-bounds causing all kinds of mayhem. ... and do nothing with the pointer if it is a lower level page table. ...
    (Linux-Kernel)
  • Re: FOR ... NEXT
    ... CELLS SWAP +! ... makes automating the loop straightforward. ... CSET-POINTER ... CSTART-LOOP (end-value start-value pointer) ...
    (comp.lang.forth)