Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
I am populating an array and to do so, the listings go WAY across the page horizontally: vaCriterion = VBA.Array("_5d_LB_True_DR", "_10d_LB_True_DR", "_20d_LB_True_DR", "_30d_LB_True_DR", "_60d_LB_True_DR", "_110d_LB_True_DR", "_120d_LB_True_DR", "_150d_LB_True_DR", "_5d_LB_ADF", "_5d_LB_beta", "_5d_LB_DR_IR", "_5d_LB_DR_sd", "_10d_LB_ADF", "_10d_LB_beta", "_10d_LB_DR_IR", "_10d_LB_DR_sd", "_20d_LB_ADF", "_20d_LB_beta", "_20d_LB_DR_IR", "_20d_LB_DR_sd", "_30d_LB_ADF", "_30d_LB_beta", "_30d_LB_DR_IR", "_30d_LB_DR_sd", "_60d_LB_ADF", "_60d_LB_beta", "_60d_LB_DR_IR", "_60d_LB_DR_sd", "_110d_LB_ADF", "_110d_LB_beta", "_110d_LB_DR_IR", "_110d_LB_DR_sd", "_120d_LB_ADF", "_120d_LB_beta", "_120d_LB_DR_IR", "_120d_LB_DR_sd", "_140d_LB_ADF", "_150d_LB_ADF", "_150d_LB_beta", "_150d_LB_DR_IR", "_150d_LB_DR_sd") How can i get Excel VBA to let me make the entries vertically so that they are not out of the scope of the window. All the refernce books show it vertically but they do not say how to accomplish it. Tha nk you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting based on a vertical Array. | Excel Worksheet Functions | |||
Linest Array vertical answer return | Excel Discussion (Misc queries) | |||
Searching a limited amount of rows in a vertical array | Excel Discussion (Misc queries) | |||
How can I use SumProduct with a horizonontal and vertical array? | Excel Discussion (Misc queries) | |||
Problem w/ vertical array formula | Excel Discussion (Misc queries) |