Re: Dim MyArray vs. Dim MyArray()
From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 11/11/04
- Next message: anonymous_at_discussions.microsoft.com: "VBA to consolidate multiple worksheets to 1 worksheet in running sequence"
- Previous message: TerryP: "Re: OnAction calls to subroutine"
- In reply to: Alan Beban: "Dim MyArray vs. Dim MyArray()"
- Next in thread: Alan Beban: "Re: Dim MyArray vs. Dim MyArray()"
- Reply: Alan Beban: "Re: Dim MyArray vs. Dim MyArray()"
- Reply: Alan Beban: "Re: Dim MyArray vs. Dim MyArray()"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Nov 2004 09:23:32 -0500
> So however nimble the “underlying structure of the storage” analysis may
> be, from the errors thrown above it seems abundantly clear that the two
> constructs are not technically identical and that MyArray1() and
> MyArray2() are true Variant() arrays and not Variant variables
> containing arrays (if they were the latter, then, as demonstrated above,
> there would be no such errors).
>
> Alan Beban
The only thing I see your test illustrates is your declaration causes the
parser to apply different rules in interpreting how it tries to interpret
and implement your commands. It also seems to reinforce my basic point
that the use of
Dim myArray()
myArray() = somearray
is a waste of time and could be counterproductive.
As you said:
> We seem to keep going around the barn on this.
-- Regards, Tom Ogilvy
- Next message: anonymous_at_discussions.microsoft.com: "VBA to consolidate multiple worksheets to 1 worksheet in running sequence"
- Previous message: TerryP: "Re: OnAction calls to subroutine"
- In reply to: Alan Beban: "Dim MyArray vs. Dim MyArray()"
- Next in thread: Alan Beban: "Re: Dim MyArray vs. Dim MyArray()"
- Reply: Alan Beban: "Re: Dim MyArray vs. Dim MyArray()"
- Reply: Alan Beban: "Re: Dim MyArray vs. Dim MyArray()"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
