I think Don means for you to place the formula in the "refers to"
dialog when defining the name.


Gord

On Sat, 22 Oct 2011 20:02:40 -0700, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

On Sat, 22 Oct 2011 13:16:15 -0700 (PDT), Don Guillett
wrote:

On Oct 22, 1:18*pm, CellShocked
<cellshoc...@thecellvalueattheendofthespreadshee t.org wrote:
* I want to make a worksheet where the user places a whole number value
in a cell. *That value is then relied upon to define the number of rows
in a named range on another worksheet in the same workbook.

* So, it would define say, the number of shelf positions on a wall.

*So, the range would be from say 10 to 45 shelf positions, depending on
the user's choice of the other worksheet's referred to cell value.

* Or would it be simply easier to define a number of named ranges on the
worksheet which include the numeric, then refer to that named range in my
subsequent formula scripting

name your range colA and in the formula
=offset($a$10,0,0,a1,1)
or better yet to make it SELF adjusting based on the content of col A
=OFFSET(Sheet4!$A$10,0,0,MATCH("*",Sheet4!$A:$ A,-1)-9,1)


That formula goes in the what cell?

The sheet1 cell has say 40 in it, the sheet2 array would then be 40
rows x whatever number of columns.

I can sort of see what is going on here, but I do not know where to put
the formula. What? Cell A1 of sheet4? I am a bit confused.