| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula not returning value
I have a formula set up as a macro, I have used it numerous times with no
problem. Now I run the macro and all I see is the formula itself, no value, no error, just the formula. I've checked and none of the columns are formatted as text. Also, in case something had happened to my macro, I manually typed out the formula with the same result. I have switched the cell format a few times to see if that would help and no luck. Any suggestons? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula not returning value
try touching CNTRL-`
you may be in formula display mode rather then value mode -- Gary''s Student - gsnu200732 "ESPN" wrote: I have a formula set up as a macro, I have used it numerous times with no problem. Now I run the macro and all I see is the formula itself, no value, no error, just the formula. I've checked and none of the columns are formatted as text. Also, in case something had happened to my macro, I manually typed out the formula with the same result. I have switched the cell format a few times to see if that would help and no luck. Any suggestons? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula not returning value
That did it! Thanks.
"Gary''s Student" wrote: try touching CNTRL-` you may be in formula display mode rather then value mode -- Gary''s Student - gsnu200732 "ESPN" wrote: I have a formula set up as a macro, I have used it numerous times with no problem. Now I run the macro and all I see is the formula itself, no value, no error, just the formula. I've checked and none of the columns are formatted as text. Also, in case something had happened to my macro, I manually typed out the formula with the same result. I have switched the cell format a few times to see if that would help and no luck. Any suggestons? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| look up formula not returning data | Excel Worksheet Functions | |||
| Formula returning the worksheet name | Excel Discussion (Misc queries) | |||
| Returning the formula in a cell | Excel Discussion (Misc queries) | |||
| Returning the x value of a formula | Excel Discussion (Misc queries) | |||
| Formula returning #N/A | Excel Worksheet Functions | |||
Linear Mode
