Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define an array with variable size
Hi all,
In my Excel VBA program, I have to define an array, but the dimension of this array is a variable, which dependents on the value in cell B1. I think this is an easy problem but I don't know how to solve it _< Thanks very much for your help!! Best wishes C.F. Yiu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define an array with variable size
Hi
have a look at 'ReDim' in the Exel VBA help for this -----Original Message----- Hi all, In my Excel VBA program, I have to define an array, but the dimension of this array is a variable, which dependents on the value in cell B1. I think this is an easy problem but I don't know how to solve it _< Thanks very much for your help!! Best wishes C.F. Yiu . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define an array with variable size
Hi Choi Fan,
Sub Test() Dim Arr() As Variant Dim i As Long i = Range("A1").Value ReDim Arr(1 To i) End Sub --- Regards, Norman "Yiu Choi Fan" wrote in message ... Hi all, In my Excel VBA program, I have to define an array, but the dimension of this array is a variable, which dependents on the value in cell B1. I think this is an easy problem but I don't know how to solve it _< Thanks very much for your help!! Best wishes C.F. Yiu |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define an array with variable size
Choi Fan,
Option Explicit Sub ArrayDimension() Dim vArray As Variant ReDim vArray(0 To Sheets(1).Range("A1").Value) MsgBox UBound(vArray, 1) End Sub The traffic is hell in Central if you are trying to get home that way. Just took me 25 minutes to get past the Convention Centre from the Star Ferry. Robin Hammond www.enhanceddatasystems.com "Yiu Choi Fan" wrote in message ... Hi all, In my Excel VBA program, I have to define an array, but the dimension of this array is a variable, which dependents on the value in cell B1. I think this is an easy problem but I don't know how to solve it _< Thanks very much for your help!! Best wishes C.F. Yiu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define Variable Name using VBA | Excel Discussion (Misc queries) | |||
Using a Variable to Define Series | Charts and Charting in Excel | |||
How to find out the size of a variable-size array ? | Excel Programming | |||
Define variable range | Excel Programming |