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
Bookmarks