I have a spreadsheet and am running so code across the sheet, all of a sudden
instead of applying the code it is now just putting the formulas in the
cells, I know a setting has changed somewhere but I can't find it

Any suggestions

THanks

Try Ctrl+` (which is the tilde key next to the #1 at the top). That
key combination toggles your view from formulas to values.
Nigel wrote:
I have a spreadsheet and am running so code across the sheet, all of a sudden
instead of applying the code it is now just putting the formulas in the
cells, I know a setting has changed somewhere but I can't find it

Any suggestions

THanks

If no formulas are working, then go to Tools=Options, and under view,
uncheck Formulas down toward the bottom section.

You can also toggle that view with Ctrl+ the key on the left of the number
row - tilde for me in the US, but it differs based on regional keyboard.


Otherwise, if some formulas are working and some are just displayed, make
sure the cells with the displayed formulas are not formatted as text (or
don't refer to cells formatted as text) and don't have a space in front of
the equal sign.

--
regards,
Tom Ogilvy


"Nigel" wrote:

I have a spreadsheet and am running so code across the sheet, all of a sudden
instead of applying the code it is now just putting the formulas in the
cells, I know a setting has changed somewhere but I can't find it

Any suggestions

THanks

Tom you hit it on the head, the data was coming from a showcase query and
the cells where the formulas where being entered were marked as text, changed
whole spreadsheet to general and everything was perfect

thanks


"Tom Ogilvy" wrote:

If no formulas are working, then go to Tools=Options, and under view,
uncheck Formulas down toward the bottom section.

You can also toggle that view with Ctrl+ the key on the left of the number
row - tilde for me in the US, but it differs based on regional keyboard.


Otherwise, if some formulas are working and some are just displayed, make
sure the cells with the displayed formulas are not formatted as text (or
don't refer to cells formatted as text) and don't have a space in front of
the equal sign.

--
regards,
Tom Ogilvy


"Nigel" wrote:

I have a spreadsheet and am running so code across the sheet, all of a sudden
instead of applying the code it is now just putting the formulas in the
cells, I know a setting has changed somewhere but I can't find it

Any suggestions

THanks