Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When you assign values in a range to a variant, I read that the indexes are
always one-based, even if Option Base 0 is explicitly declared. Example: Option Base 0 Dim SalesData SalesData=Range("A1:F10000") Customer = SalesData Would that apply if the coder did this, using the "()", a dynamic array of variants?: Option Base 0 Dim SalesData() SalesData()=Range("A1:F10000") Customer = SalesData() I'm also curious, does the code, "Customer = SalesData", assign the same value as would "Customer = SalesData()"? I ask because I'm working on some code where the Devleoper wrote code and I'm trying to figure out whether declaring Option Base would have any impact: Dim varAddr() varAddr() = Range("h2:h65536") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Functions - Two Questions | Excel Worksheet Functions | |||
Web Query & Array Questions! | Excel Programming | |||
Array questions | Excel Programming | |||
Listbox and Array questions | Excel Programming | |||
Array Questions | Excel Programming |