How to read data from a worksheet into an array in a module?

[tstav]

I imported a set of data in a work sheet and need to use it as an array for all the macros the I used in the workbook. Just how do I make this work?

Suppose your data range is Range("A1:B3"). (You change it to whatever your data range is).
Declare a dynamic Array of variant data type.
Dimension it according to the RowsNumber and ColumnsNumber of your range.
Assign the range to this Array.
[vba]Dim Arr() As Variant
Sub RangeToArray()
Dim R as Range
Set R = Range("A1:B3")
ReDim Arr(R.Rows.Count, R.Columns.Count)
Arr = R
End Sub[/vba]