A20 is not a column.

Formulas cannot add rows.

You will need VBA code to add your rows.

Where do you want the rows added and which two cells contain the numbers 40
and 30


Gord Dibben MS Excel MVP

On Tue, 2 Sep 2008 14:01:01 -0700, Six Sigma Blackbelt
wrote:

I need to automically add rows to my worksheet. The number of rows will be
derived from a number that is sum by two other numbers inputed into the
sheet. The sum number will dictate how many rows to generate numerically.
Example, so if the two numbers to be sum are 40 + 30 the sum is 70, I need
excel to generate 70 numerical (1-70) rows in a specified column like A20,
how can I produce this in a formula?

Stuck, spinning wheels

MJS