Can Redim be used to declare a new array ?
Answers were Sorted based on User's Feedback
Answer / m.chitramala
No We can't use redim to declare a new array. Redim is used
to resize the declared array
Is This Answer Correct ? | 35 Yes | 3 No |
Answer / padma
M. chitramala is right. Redim is to resize the exiting
array variable.
sample:
Dim myarray() as string
Redim myarray(10)
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / pradeepa v
Redim is used to increase the dimension/size of the array.
Preserve keyword is used to hold the previous value of the
array.
ex: Redim Preserve a[20]
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / shetty
redim can only be used to increase/decrease the size of the
existing array.it cannot be used to create a new array.
srinivas shetty
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ashok s bhosale
Redim can be Used Create New array of different length
eg
Dim arr() As Integer
ReDim arr(3)
arr(0) = 1
arr(1) = 2
arr(2) = 3
MsgBox arr(0) & ":" & arr(1) & ":" & arr(2)
'It Print 1,2,3
ReDim arr(4)
MsgBox arr(0) & ":" & arr(1) & ":" & arr(2) & ":" & arr(3)
it display 0,0,0,0
it reinitilize all element to 0 it means it create new Array
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / abdul khadeer
We can reinitialize the array by using REDIM but the
condition is before data, what ever the array is having
that is going to be deleted or reinitialized to zero.
So there is one solution for this:
For Example We can use the "Preserve" keyword with the
redim to reintialize the Array with old values still exists.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / prasad
yes friends its right redim is used to resize the decalred
array realier in the program
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kumari santosh
Yes, Using Redim statement the size is set at runtime.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kapil
Yes Redim Can be used to create a new array.
There is no need of the dim statement before using ReDim.
Following Code works :
Redim a(5) as int
a(0) = 3
debug.print a(0)
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sb
if I redim an array and increase its size. will the
existing elements in the array be lost?
Is This Answer Correct ? | 2 Yes | 0 No |
what are the Parts of ODBC?
What is Static Cursor?
Default cursor Type and LockEdit type in DAO?
How do I add a form in visual basic?
What is the difference Between ADO and other data access objects?
Which property of textbox cannot be changed at runtime. What is the max size of textbox?
What are 3 main differences between flexgrid control and dbgrid control?
What is the difference between message box
How would you create properties by using class Builder Wizard?
How do I make an animated icon for my program?
How to find size of the file. Which method or function is used to occomplish this?
Explain Default cursor Type and LockEdits type in RDO?