Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Array Contents
Often I need to see the contents of my array to verify that I am doing things
correctly. About the only ways I know how to do this is the "Hover" method where the yellow popup will come over the currently-pointed to array. But the popup doesn't always work and besides, it only shows me the value of the array for the elements that are set and I want to "browse" the entire contents of the array. Is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Array Contents
While your code is sitting on a break point or what for an F8 to step next,
go to the Debug window, choose Add Watch and eneter your array variable name in the Expression to watch. This will display the current and changing values of the array. Click the "+" symbol in the Watch window to view a list of all elements of the array and their values. "Mike H." wrote in message ... Often I need to see the contents of my array to verify that I am doing things correctly. About the only ways I know how to do this is the "Hover" method where the yellow popup will come over the currently-pointed to array. But the popup doesn't always work and besides, it only shows me the value of the array for the elements that are set and I want to "browse" the entire contents of the array. Is this possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Array Contents
You can also type the following in the Immediate window while you are at a
break point or wait on a step: for n = 1 to 3 : debug.Print v(n) :next n Change 'v' to the name of the array ane change 1 and 3 to the lower and upper elements you wish to view. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Mike H." wrote in message ... Often I need to see the contents of my array to verify that I am doing things correctly. About the only ways I know how to do this is the "Hover" method where the yellow popup will come over the currently-pointed to array. But the popup doesn't always work and besides, it only shows me the value of the array for the elements that are set and I want to "browse" the entire contents of the array. Is this possible? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Array Contents
That is totally awesome. I can see "everything" in there! Thanks a lot!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Links Dialog Box too long to view contents | Links and Linking in Excel | |||
Can't view worksheet contents, but I can do Print Preview and see | Excel Discussion (Misc queries) | |||
spreadsheet contents have become hidden from view | Excel Discussion (Misc queries) | |||
Why can't I view the contents of a cell? | Excel Discussion (Misc queries) | |||
UserForm to view contents of spreadsheet | Excel Programming |