Watch All

[Carly]

Hi,

I am just been lazy, I know, but is there a way you can 'Watch' all variables without having to stipulate all of them one by one?

 

[CharlesChuckieCharles]

You can drag selected expressions from the Code window into the Watch window.

 

[Carly]

I have the following section of code and I'd like to watch all of the variables individually:

Global v1stCell, v2ndCell, v3rdCell, v4thCell, v5thCell, v6thCell, v7thCell, v8thCell, v9thCell, v10thCell, v11thCell, vNB1stCell, _
    v1stCol, v2ndCol, v3rdCol, v4thCol, vCurrent, vYear As Variant

 

[Norie]

Carly

You can use the Locals window to watch all the variables in the current sub.

Other than that your kind of stuck with dragging as Charles... suggested.

 

[Norie]

Carly

The will all appear in the Local Window.

Probably because their scope extends to all subs and modules.

 

[Carly]

Thank you very much, I never knew about the Locals Window (Every day's a school day), If I switch between the Call Stacks when it goes into the new module, it does show me the variables from the previous ones.

Thanks again.