I have a control variable sheet that has the "start" and "end" column
numbers. For a number of different data ranges that us the same start and
end columns, how do I specify the ranges in various formulas that would use
the start and end column variables but different rows? Do I have to use VBA
which I am not very good at? Thanks for any help.
--
Mal

You can create a range just like Frankenstein, splice together pieces. Say
A1 thru A4 contain:

C
F
3
5

In A5 enter:

=SUM(INDIRECT(A1&A3&":"&A2&A4))
this is the same as entering:
=SUM(C3:F5)
--
Gary''s Student - gsnu200777


"Mal" wrote:

I have a control variable sheet that has the "start" and "end" column
numbers. For a number of different data ranges that us the same start and
end columns, how do I specify the ranges in various formulas that would use
the start and end column variables but different rows? Do I have to use VBA
which I am not very good at? Thanks for any help.
--
Mal

This may be of interest to you:
http://www.contextures.com/xlNames01.html

Regards,
Ryan---

--
RyGuy


"Gary''s Student" wrote:

You can create a range just like Frankenstein, splice together pieces. Say
A1 thru A4 contain:

C
F
3
5

In A5 enter:

=SUM(INDIRECT(A1&A3&":"&A2&A4))
this is the same as entering:
=SUM(C3:F5)
--
Gary''s Student - gsnu200777


"Mal" wrote:

I have a control variable sheet that has the "start" and "end" column
numbers. For a number of different data ranges that us the same start and
end columns, how do I specify the ranges in various formulas that would use
the start and end column variables but different rows? Do I have to use VBA
which I am not very good at? Thanks for any help.
--
Mal

Whoops, hit the 'Post' button too fast; ment to give you this too:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Regards,
Ryan--

--
RyGuy


"ryguy7272" wrote:

This may be of interest to you:
http://www.contextures.com/xlNames01.html

Regards,
Ryan---

--
RyGuy


"Gary''s Student" wrote:

You can create a range just like Frankenstein, splice together pieces. Say
A1 thru A4 contain:

C
F
3
5

In A5 enter:

=SUM(INDIRECT(A1&A3&":"&A2&A4))
this is the same as entering:
=SUM(C3:F5)
--
Gary''s Student - gsnu200777


"Mal" wrote:

I have a control variable sheet that has the "start" and "end" column
numbers. For a number of different data ranges that us the same start and
end columns, how do I specify the ranges in various formulas that would use
the start and end column variables but different rows? Do I have to use VBA
which I am not very good at? Thanks for any help.
--
Mal

Thanks Ryan....Named Ranges are under-utilized and should be given more
publicity.
--
Gary''s Student - gsnu200778


"ryguy7272" wrote:

Whoops, hit the 'Post' button too fast; ment to give you this too:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Regards,
Ryan--

--
RyGuy


"ryguy7272" wrote:

This may be of interest to you:
http://www.contextures.com/xlNames01.html

Regards,
Ryan---

--
RyGuy


"Gary''s Student" wrote:

You can create a range just like Frankenstein, splice together pieces. Say
A1 thru A4 contain:

C
F
3
5

In A5 enter:

=SUM(INDIRECT(A1&A3&":"&A2&A4))
this is the same as entering:
=SUM(C3:F5)
--
Gary''s Student - gsnu200777


"Mal" wrote:

I have a control variable sheet that has the "start" and "end" column
numbers. For a number of different data ranges that us the same start and
end columns, how do I specify the ranges in various formulas that would use
the start and end column variables but different rows? Do I have to use VBA
which I am not very good at? Thanks for any help.
--
Mal