Un-select Cell with VBA

[mgarciadelacruz]

Hi,

I'm working in a macro, and in the SelectionChange procedure, the following code


ActiveCell.Select

Selection.Copy

Range("AG44").PasteSpecial _

Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _

False, Transpose:=False


is copying the value of the selected cell to an specific cell. How is it possible to de-select the activecell?


Thanks

 

[Hui]

add this line after your Paste line


Application.CutCopyMode = False

 

[mgarciadelacruz]

It worked!


Thanks a lot for your quick answer