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

Range(Range("x5"), Range("x5").End(xlDown)).Select
Selection.Value = Selection.Value

**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

Option Explicit

Sub hh()
    Range("X5").FormulaR1C1 = _
    "=SUMPRODUCT(--(R5C16:R1500C16=RC[-8]),R5C20:R1500C20)"
    Range("X6").FormulaR1C1 = _
    "=IF(EXACT(R[-1]C[-8],RC[-8]),"""",SUMPRODUCT(--(R5C16:R1500C16=RC[-8]),R5C20:R1500C20))"
    Range("X6").AutoFill Destination:=Range("X6:X1500"), Type:=xlFillDefault
    Range("X5:X1500").Value = Range("X5:X1500").Value
End Sub

**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

I want to modify the code

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

I want to modify the code

Re: I want to modify the code

Re: I want to modify the code

Re: I want to modify the code

Re: I want to modify the code

Re: I want to modify the code

Re: I want to modify the code

Re: I want to modify the code

Re: I want to modify the code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions