Thread: How to code ReDim Preserve when "ReDim strArr(1 To 100, 1 To 3)"
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] EagleOne@discussions.microsoft.com is offline
external usenet poster
  
Posts: 391
Default How to code ReDim Preserve when "ReDim strArr(1 To 100, 1 To 3)"
Thanks Bob

"Bob Phillips" wrote:

You can only redim the 2nd dimension

Dim strArr() As String
Dim iCtr as Long

ReDim strArr(1 To 3, 1 To 100)
......
......

Getting an error if I code:
ReDim Preserve strArr(1 to 3,1 To iCtr)
Reply With QuoteReply With Quote