I want to modify the code

**hesham63** · 07-30-2011, 07:15 AM

hi
This code works well

HTML Code:

I want to do not appear in the equations cells

**Sadath31** · 07-30-2011, 07:39 AM

I think you want to convert the formula into value
then include the code to your macro

Please Login or Register  to view this content.

**hesham63** · 07-30-2011, 07:50 AM

Really wonderful
Thank you very much

**royUK** · 07-30-2011, 07:52 AM

You don't need to switch off screen updating, especially as you don't return it to true. You also do not need to select the cells

Please Login or Register  to view this content.

**hesham63** · 07-30-2011, 08:03 AM

my dear
Is it possible to work this code automatically Without pressing the button

**royUK** · 07-30-2011, 08:41 AM

When would you want it to run?

**hesham63** · 07-30-2011, 08:43 AM

When you put the value in cell

**royUK** · 07-30-2011, 09:12 AM

Which cell? Why would that need to trigger adding all those formulas & converting to values?

**hesham63** · 07-30-2011, 10:36 AM

You right I'm sorry and I thank you

Re: I want to modify the code