Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"clear multidimensional array

Status
Not open for further replies.
magmo

magmo

Programmer
May 26, 2004
291
SE
Hi

I have this code....

Code: 
Dim arrMyArray(,) As Integer    ' No bounds yet.
ReDim arrMyArray(iCounter, 6)          ' Give it bounds.

If I only want to "clear" the values that the array has been assigned to it, how would I do that?


Regards
 
Sort by date Sort by votes
Correct me if I'm wrong, but I don't believe the .clear method works on multidimensional arrays.

To just clear the data and keep the bounds, see if this is what you are looking for.
:) -Andrew
Code: 
dim row, col as integer
row = ubound(arrMyArray,2)
col = ubound(arrMyArray,1)

redim arrMyArray(col, row) ' keeps bounds
redim arrMyArray(-1)       ' does not keep bounds
' in both cases, data is cleared.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
FIND ARRAY IN OTHER ARRAY
Replies
3
Views
385
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
fill array from recordset
Replies
6
Views
781
2009luca
2009luca
sal21
  • Locked
  • Question
clear textbox in frame1 2
Replies
2
Views
265
strongm
strongm
Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
1K
strongm
strongm
Niki_S
  • Locked
  • Question
How to use 2D array in vb 6? 1
Replies
10
Views
551
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top