View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cogent cogent is offline
external usenet poster
 
Posts: 32
Default Vertical Entries for VBA.Array

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