VBA when pasting the data highlighted blue color rectangle is seen

[Wither125]

Hello,

when i am pasting the data to a worksheet ,i see a highlighted rectangle with blue color. In the below pic u can see rows 3,4,5 and column A to H it has a blue color rectangle highlighted . So how do i remove this highlighted rectangle ?

light.PNG

below is the code :

Windows("kl.xls").Activate
Range("A2:G2").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy

Windows("c250k.xlsm").Activate
Sheets("Sheet1").Select
Range("A3").Select
ActiveSheet.Paste
Range("A3:H3").Select
Application.CutCopyMode = False


Regards
Wither

[mrice]

Looks like its still selected. Try adding

Please Login or Register  to view this content.

to the end.

[Wither125]

HI mrice,

Thank you it works!