on cell change enter just the value

[theresap]

I have several cells (A8:K16) with if statements like:

Please Login or Register  to view this content.

I would like the true statement to return the true value and not the if statement and formula.

Thanks for helping

[Leith Ross]

Hello theresap,

What do you mean by the true value? Is the calculated value incorrect? Can you provide some before and after examples?

[theresap]

The display value is correct. I would like the formula behind it to disappear, so only the number is in the cell.

[Leith Ross]

Hello theresap,

How to Save a Worksheet Event Macro

1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S

Please Login or Register  to view this content.

[theresap]

I followed your instructions. Since I do not know what it is telling me to do, I do not know how to "Make any custom changes to the macro if needed at this time. "
It is not working. I think it is because of the if statement: =IF($A$22="07/01/10 - 07/15/10",($H$21),"").

The other way I tried to do this was with a macro:

Please Login or Register  to view this content.

Although each week I need to change the value in Range("b9:c9").Select to the next range.
I have the range for each weekly update found in sheet1!M2.
How can I change the maco to recognize the text in sheet1!m2 to be part of the macro code for the Range?

[royUK]

How about following up on the help that has been offered for your previous post?

This post looks like a worksheet formula to me. Try explaining fully what you are dong