VBA - Application.CutCopyMode

[plix]

Hi,

After the copy/paste values, I want to "deselect" range (F24:L30).
I tried Application.CutCopyMode = False, but it does not do the trick.
Any suggestion?

<font face=Courier New>Range("F24:L30").Select<br>Selection.Copy<br>Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _<br>    <SPAN style="color:#00007F">False</SPAN>, Transpose:=<SPAN style="color:#00007F">False</SPAN><br>Application.CutCopyMode = <SPAN style="color:#00007F">False</SPAN></FONT>

Thanks,

Plix

 

[Jon von der Heyden]

You shouldn't need to the select the range at all:

With Range("F24:L30")
    .Copy
    .PasteSpecial xlValues
End With

Edit:

In fact you don't need to use copy

Range("F24:L30") = Range("F24:L30").Value

 

[VoG]

I think that this will achieve the same result:

With Range("F24:L30")
    .Value = .Value
End With

 

[plix]

Thanks both for your help.
The following works perfectly indeed:

With Range("F24:L30")
.Value = .Value
End With

Plix