Answer / m.chitramala

No We can't use redim to declare a new array. Redim is used
to resize the declared array

Answer / padma

M. chitramala is right. Redim is to resize the exiting
array variable.

sample:
Dim myarray() as string

Redim myarray(10)

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]

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

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

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.

Answer / prasad

yes friends its right redim is used to resize the decalred
array realier in the program

Answer / kumari santosh

Yes, Using Redim statement the size is set at runtime.

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)

Answer / sb

if I redim an array and increase its size. will the
existing elements in the array be lost?

What is the difference between change event in normal combobox and dbcombobox?

0 Answers  

Explain Get, Let, Set Properties.

1 Answers  

What is the use of OLE?

0 Answers   IBM,

How do I mimic a toggle button?

0 Answers  

___ property used to add a menus at runtime.

0 Answers  

by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.

0 Answers   CGI, Infotech,

What is the use of Visual Basic Document file?

0 Answers  

Clear property is available in ____,___ control.

0 Answers  

What is ODBC?

1 Answers  

Explain about manipulating the recordset object

0 Answers  

How many system controls are available ?

1 Answers  

What is the use of Visual Basic Document file?

0 Answers