Copy Paste Optimum Tested Method in VBA

Question

Dear Sir,

Good Morning.

I found that when i use normal copy paste method like

Range("g7:j10").Copy
Range("g14").PasteSpecial xlPasteValues

But it is making screen disappear. 

How to rewrite this line to make sure that screen is stable always?

Please advice.

Thanks.

Best Regards,

Answer 1

Hello, I am Leonielhou, an Independent Advisor and a user like you, I am happy to help clarify any questions you may have.

This works for me.

Sub Sheetname () Application.ScreenUpdating = False Range("G7:J10"). Copy Range("G14"). PasteSpecial xlPasteValues Application.CutCopyMode = False Application.ScreenUpdating = True End Sub

Answer 2

Hi there

You may try the following line of code

Range("G14:J17").Value=Range("G7:J10").Value

Regards

Jeovany

Answer 3

Hi ExcelSuperXW!

Try this

Sub Copy_Range()

Range("G7:J10").Copy Range("G14")

End Sub

Perhaps you should add the following code to your code,

Paste this at the beginning of your code

Application.ScreenUpdating = False '

Paste this at the end of the code

Application.ScreenUpdating = True

Kind Regards,

Shakiru