Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all. Over the last month or so, I have familliarized myself (almost
painfully so) with utilizing arrays and loops together in my macros for efficiency (and sanity). What I am wondering, is how do you load an array dynamically? I know well how to declare one such as V = Array("stuff","morestuff") etc etc However what if the contents of the array need to change on a weeky basis? I hate having to go in and reprogram it, and was wondering if there was a way to load it dynamically? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamically load DataValidation List through Source field? | Excel Worksheet Functions | |||
load addresses of selected cells into array | Excel Programming | |||
Load a static array at procedure level | Excel Programming | |||
Load excel range into multi dimensional array | Excel Programming | |||
Load an array with Sheet names | Excel Programming |