Avoiding select in VBA

[alrodopial]

Here comes "Select" again.
I want to copy a range with formulas "A1:A10" and paste them into lets say cell C5 with the transpose but without using the "select" in the VBA.
in C5 will be the formula from A1,in D5 the formula from A2 etc.
the below code doesn't use the "select" but when it pastes special the screen is moving , exactly as when using the "select".
It's the same and if I use the "ScreenUpdating = False" at the beginning.

Code: Select all

Set Rng = wsBF1.Range("J206:J216")
    Rng.Copy
    wsBF1.Range("J200").PasteSpecial Paste:=xlPasteFormulas, Transpose:=True

Any ideas?

[alrodopial]

Instead of "ScreenUpdating = False"
I used
"Application.ScreenUpdating = False"

It works fine.