Viewing variable values

Hi Roger

Thanks for getting in touch.

The Locals window certainly should show the values of arrays. You have specified that it's in the General Declarations area, so it is possible that they are not executed during the macro you happen to be stepping through?

Have you double-checked the variable is being populated at all? Perhaps try a MsgBox with the array name in? You could loop through the values to output the current values at some point in the code.

Sorry I can't help further at this point - try that out and see what happens.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector