I am working with a customer supplied Excel worksheet where a range of cells
is selected for each use of the worksheet. For example the range may be row
52350 thru 53750 (note: this range varies with each file analyzed) There are
equations that would then use this range with data from various columns, such
as =average(AB52350:AB53750) and =max(Z52350:Z53750), etc. What I would like
to do is input the row numbers in a cell and have them automatically inserted
into the formulas.

AVERAGE(INDIRECT("k" & A22 & ":k" & A23))
MAX(INDIRECT("l" & A22 & ":l" & A23))

With start row in a22 and ending row in a23. Note: I used columns k and l
for my test (as I already suitable data in those columns.) Substitute AB for
k and Z for l.

--
Kevin Vaughn


"BC2233" wrote:

I am working with a customer supplied Excel worksheet where a range of cells
is selected for each use of the worksheet. For example the range may be row
52350 thru 53750 (note: this range varies with each file analyzed) There are
equations that would then use this range with data from various columns, such
as =average(AB52350:AB53750) and =max(Z52350:Z53750), etc. What I would like
to do is input the row numbers in a cell and have them automatically inserted
into the formulas.

Thanks Kevin works great!

"Kevin Vaughn" wrote:

AVERAGE(INDIRECT("k" & A22 & ":k" & A23))
MAX(INDIRECT("l" & A22 & ":l" & A23))

With start row in a22 and ending row in a23. Note: I used columns k and l
for my test (as I already suitable data in those columns.) Substitute AB for
k and Z for l.

--
Kevin Vaughn


"BC2233" wrote:

I am working with a customer supplied Excel worksheet where a range of cells
is selected for each use of the worksheet. For example the range may be row
52350 thru 53750 (note: this range varies with each file analyzed) There are
equations that would then use this range with data from various columns, such
as =average(AB52350:AB53750) and =max(Z52350:Z53750), etc. What I would like
to do is input the row numbers in a cell and have them automatically inserted
into the formulas.

You are welcome.
--
Kevin Vaughn


"BC2233" wrote:

Thanks Kevin works great!

"Kevin Vaughn" wrote:

AVERAGE(INDIRECT("k" & A22 & ":k" & A23))
MAX(INDIRECT("l" & A22 & ":l" & A23))

With start row in a22 and ending row in a23. Note: I used columns k and l
for my test (as I already suitable data in those columns.) Substitute AB for
k and Z for l.

--
Kevin Vaughn


"BC2233" wrote:

I am working with a customer supplied Excel worksheet where a range of cells
is selected for each use of the worksheet. For example the range may be row
52350 thru 53750 (note: this range varies with each file analyzed) There are
equations that would then use this range with data from various columns, such
as =average(AB52350:AB53750) and =max(Z52350:Z53750), etc. What I would like
to do is input the row numbers in a cell and have them automatically inserted
into the formulas.