On Oct 23, 8:39*am, CellShocked
<cellshoc...@thecellvalueattheendofthespreadsheet. org wrote:
On Sat, 22 Oct 2011 23:51:50 -0700, Gord Dibben wrote:
I think Don means for you to place the formula in the "refers to"
dialog when defining the name.

* I will try that. *Thanks.

* I still don't see it.

* I named A1 on sheet1 'colA' and then I edited the name in name manager
to that formula but pointed it at sheet2 instead. *But I still do not
understand.

*I want to have a cell that is for defining the array size row count.

*so the user see in sheet one a series of field to fill data in on. *One
of those fields is used to set the number of rows in the data array.

*So my sheet1 is the user data input sheet, and the results get referred
to on subsequent 'display' sheets.









Gord

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

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

On Oct 22, 1:18*pm, CellShocked
<cellshoc...@thecellvalueattheendofthespreadshe et.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.

Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com