auto fill of formulas

[Guest]

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.......

 

[Ken Johnson]

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

 

[Gord Dibben]

Perhaps Tools>Options>Edit>Extend 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