View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default those little "moving lines"

Hi
Don't put them in!
Worksheets("Items in F4106 Weight OK").Range("L2:M2.Copy
ActiveSheet.Paste Destination:=Worksheets("Items in F4106 Weight
OK").Range("L3:L" & rcount18)

You can Always leave out the select when copying (which is what puts
the lines in)
regards
Paul

On Sep 12, 3:53*pm, Eric @ BP-EVV
wrote:
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 !