varying a range in a formula

**Justme47** · 05-30-2009, 04:51 PM

I need some programming help to control the length of the range in the formula below:

Please Login or Register  to view this content.

The start and stop values of the range are in the worksheet in cell C10 and C11 as integers.
Is it possible to change this formula in such a way that the formula is controlled by the content of the cells C10 and C11?

Your help will be appreciated very much.

**mewingkitty** · 05-30-2009, 04:55 PM

How do you mean that they're integers.
There are 2 cells named,
A2 and A10
That would require 4 integers to define:
IE
cells(2, 1) and cells(10, 1)
2,1,10,1

What is the content of C10 and C11?

**Justme47** · 05-30-2009, 05:12 PM

The following was meant:

In cell C10 and C11 are the values to which the range must be changed.
When e.g. in C10 is 25 and in C11 is 35 the the range should be

Please Login or Register  to view this content.

Is this possible to change this formula acordingly or is there another solution e.g. a UDF?

**DonkeyOte** · 05-30-2009, 06:05 PM

You can use VBA

Please Login or Register  to view this content.

If doing natively (ie entering formula into cell without VBA) you could use INDEX (preferable to INDIRECT as non-volatile), eg:

Please Login or Register  to view this content.

**Justme47** · 05-31-2009, 10:09 AM

The Code option using Range in the formula works only when the macro is run.
The Code option, using INDEX, works fine for me

Thanks for your help DonkeyOte