View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Eric @ BP-EVV Eric @ BP-EVV is offline
external usenet poster
 
Posts: 43
Default those little "moving lines"

Thanks Paul ! I didn't know you could copy without first selecting !

" wrote:

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 !