View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default those little "moving lines"

Use

Application.CutCopyMode = False

after the Paste operation. FYI, the "moving lines" are often called the
"marching ants".


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Eric @ BP-EVV" wrote in message
...
After the following section of vba code runs, the little "moving lines"
that
show the range of cells as selected are still there....how do I un-select
that range ?

Worksheets("Items in F4106 Weight OK").Range("L2:M2").Select
Selection.Copy
ActiveSheet.Paste Destination:=Worksheets("Items in F4106 Weight
OK").Range("L3:L" & rcount18)

Thanks !