Re: Redim 2D Array Subscript Out Of Range Error
From: Alan Beban (alannospambeban_at_pacbell.net)
Date: 02/09/04
- Next message: Full Monty: "Re: Save Workbook using List Box Data"
- Previous message: morry: "Finding duplicate value in another workbook"
- In reply to: Tom Ogilvy: "Re: Redim 2D Array Subscript Out Of Range Error"
- Next in thread: lopsided: "Re: Redim 2D Array Subscript Out Of Range Error"
- Reply: lopsided: "Re: Redim 2D Array Subscript Out Of Range Error"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 09 Feb 2004 13:00:33 -0800
Tom Ogilvy wrote:
> You will have to check with the OP on that - I wasn't debugging his code,
> just suggesting how to alter the array. After all, he was the one that said
> it worked fine as a 1D array, so I assume he left a line of code out. And
> actually it is the whole while Wend construct that loops, not just the code
> below !! NO ERROR HERE!!
I didn't say "the code below !! NO ERROR HERE!!"; I said "the code
below". The code that was below in my post began with Dim
varChargeArray() and ended with Wend.
>
> It would seem a real waste of resources to use some generalized array
> resizing routine when it is not required at all if the dimensions of the
> array are reversed as I suggested. Even doing an application.Transpose on
> each side is unnecessary.
>
I don't necesssarily disagree (though I'm always chary of accepting
claims of things like "a real waste of resources" in the complete
absence of any context whatsoever). I suggested an alternative in case
it isn't convenient for the OP to rearrange the dimensions of his stuff.
I'm comfortable letting a user decide what "resources" are relevant and
whether a generalized resizing routine might "waste" them.
Alan Beban
- Next message: Full Monty: "Re: Save Workbook using List Box Data"
- Previous message: morry: "Finding duplicate value in another workbook"
- In reply to: Tom Ogilvy: "Re: Redim 2D Array Subscript Out Of Range Error"
- Next in thread: lopsided: "Re: Redim 2D Array Subscript Out Of Range Error"
- Reply: lopsided: "Re: Redim 2D Array Subscript Out Of Range Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|