Formula not returning value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
try touching CNTRL-`
you may be in formula display mode rather then value mode
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Hide columns based on row values 2
Macro/Forumula to SUM values from Sheet that does not always exist 1
Worksheet Names using Macros 5
Finding NEXT to last, non zero numeric value in a row 3
Count entries in the column translating to minutes. 5
Excel VBA 1
Formula (or code) return the largest number of duplicates in a list. 16

Back
Top