Fetching values from an array in VBA Excel

Question

I have built an array, when I add it to watch

dict.Items

It returns

Expression                    Values
dict.Items                  
--dict.Items(0)                "value in it"
--dict.Items(1)                "value in it"
--dict.Items(2)                "value in it"

But when I try to add watch to expression

dict.Items(0)

It returns the following

Watch :   : dict.keys(0) : <Property let procedure not defined and property get procedure did not return an object> : Variant/Empty : VBAProject.basMigration.UniqueReport

enter image description here

I should probably elaborate: Items simply returns the whole array, so you'd need to watch: Items()(0) rather than Items(0) — Rory
– Rory, Commented Apr 27, 2015 at 13:04

Rory · Accepted Answer · 2015-04-27 15:19:07Z

1

The Items method doesn't take an index - it only returns the whole array, so you'd need to add a watch for Items()(0) rather than Items(0)

answered Apr 27, 2015 at 15:19

Rory

34.2k5 gold badges40 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fetching values from an array in VBA Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related