auto fill of formulas
 

I have some spreadsheets that will automatically copy the formula above when
data is entered in the cell to the left of the cell where the formula is
needed. I can't find how this feature is turned on.......

auto fill of formulas
 

wpm wrote:
I have some spreadsheets that will automatically copy the formula above when
data is entered in the cell to the left of the cell where the formula is
needed. I can't find how this feature is turned on.......

It sounds like a Worksheet_Change event procedure.
Is the code in that worksheet's code module? If not then you will have
to copy/paste from a sheet that does have the code.
Have macros been enabled when the workbook was opened?
Are Events enabled, or has a previous error turned events off without
turning them back on?

Ken Johnson

auto fill of formulas
 

Perhaps ToolsOptionsEditExtend Data Range Formats and Formulas?

About half the time it doesn't work for me but I get surprised on occasion<g


Gord Dibben MS Excel MVP

On Wed, 20 Sep 2006 12:57:01 -0700, wpm wrote:

I have some spreadsheets that will automatically copy the formula above when
data is entered in the cell to the left of the cell where the formula is
needed. I can't find how this feature is turned on.......