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

  • Thread starter Thread starter ramana
  • Start date Start date
R

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

specify non-contiguous cell range as arguments to TTEST() 2
nested formula with if condotion 2
How to write for copying a cell value to another cell 1
If any specific #s are present in range, show each in another cell 6
Display row number of the last value in a column 4
Select a range of non-adjacent cells in Excel? 12
Counting cells in a selectable date range 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0

Back
Top