Working with ranges

I want make special statistical tests using Excel.
Without using ranges it is very difficult to make certain calculations.
The tests will be about statistical distributions that are not included in Excel Analysis Toolpaks.
I want to learn about using ranges in Excel.
I have read about using ranges in formulas.

For example;
the sample may consist of two variables each having different number of records; weight (30 rows), height (43 rows).

I want to create a variable length range, but I don't know how.

Hello Okaderli,

Here is a code example that assigns either the weight range or the height range to a range variable named "Rng". The weight range is "A1:A30" and the height range is "B1:B43". Both ranges are located on worksheet "Sheet1".

Examples:

Please Login or Register  to view this content.

These next examples assume there are header labels in row 1 and "A1" is labeled "Weight" and "B1" is labeled "Height". Both Names have been entered with their defined ranges of "A1:A30" and "B1:B43".

Examples with named ranges:

Please Login or Register  to view this content.

Example of finding a Range's length:

Please Login or Register  to view this content.

Sincerely,
Leith Ross