How to Specify a range using another cell vale instead of row number

[ramana]

Hi Everybody,

Normally when we specify range in excel we specify as
$A$1:$A$1000, But I for my specific problem I need to specify range
using a vlue of a cell. i.e. $A$1:$A$B1, Where B1 can have a value
between 2to 1000, Is it possible, If so Pl. tell me in what method I
can do That.

Thanks and Regards

Ramana