| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vertical Entries for VBA.Array
Use the line continuation character "_"
vaCriterion = VBA.Array("_5d_LB_True_DR", _ "_10d_LB_True_DR", "_20d_LB_True_DR", _ "_30d_LB_True_DR", I think the max limit is 24. "cogent" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vertical Entries for VBA.Array
In VB statements, you can break a long line of code by placing an underscore at the position your want to break the line
vaCriterion = 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" Regards Edwin Ta http://www.vonixx.co ----- cogent wrote: ---- Hell I am populating an array and to do so, the listings go WAY across the pag 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 the are not out of the scope of the window. All the refernce books show i vertically but they do not say how to accomplish it Tha nk yo |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vertical Entries for VBA.Array
I see.
I was missing the quotation mark at the beginning of the new line. Thanks! "cogent" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
