Hi,

Dim v as Variant
v=raNGE("A1:C100")
--- v is now a 2-d array

Using an array might not be the bets way though. It might be more efficient
do either:
- filter the range through code the build the array based on the shorter
filtered cells
- filter the range through code and work with this shorter range of cells
directly without using an array.
This will depend on what you are tryiong to accomplish in later processing
of the array.

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"David" wrote:

pls how do i convert excel sheet data to 2-D array using VBA macro. i intend
filtering and extracting info from this array. thanks.