Can you dimension an array in a way other than Variant?

Posted to microsoft.public.excel.programming

ExcelMonkey ExcelMonkey is offline

external usenet poster

Posts: 553

Can you dimension an array in a way other than Variant?

I am loading text into a large array dimensioned as a Variant. Is this the
only way to dimension the Array? I am wondering if I can dimension the array
in a less memory intensive manor?

Thanks

EM

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order)	Keith R[_2_]	Excel Programming	3	November 13th 07 04:08 PM
Array problem: Key words-Variant Array, single-element, type mismatch error	davidm	Excel Programming	6	November 9th 05 05:54 AM
Array problem: Key words-Variant Array, single-element, type mismatch error	davidm	Excel Programming	1	November 8th 05 04:21 AM
Mutli-dimensional Array to Single-Dimension Array	Blue Aardvark	Excel Programming	3	October 15th 05 09:22 AM
Array transfer - 1 dimension v. 2 dimension	JWolf[_2_]	Excel Programming	2	June 29th 04 01:02 AM

All times are GMT +1. The time now is 03:35 PM.

Menu

About Us