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 !
|