Arrays
John,
Try something like the following: Dim N As Long Dim Arr() As String N = 24 ReDim Arr(N) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "John Brown" wrote in message ... Is there any way of declaring an array without putting a fixed number? For example say I have the following Dim number As Integer number = 24 Dim array(number) As String..... I need to do this because the size of the array varies depending on how many elements I bring in from a file. Sometimes I have 100 sometimes 40 ... is there any way to do this with VB? Thanks in advance. |
All times are GMT +1. The time now is 11:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com