Ding ding ding ding....we have a winner ! Thanks Andy...I used the one line
approach:

Range("A1:A3").copy Destination:=Range("B1")

and the 'marching ants' (I like that so much better than 'moving lines')
have taken a hike out of my spreadsheet !

Thanks for the help and education !

"Andy Pope" wrote:

Hi,

If you execute as 2 commands then the 'marching-ants' will appear, even
without the .Select

So with lines,
Range("A1:A3").copy
Activesheet.paste Range("B1")

Without lines

Range("A1:A3").copy Destination:=Range("B1")


Or this will also remove the lines,
application.CutCopyMode= false

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Eric @ BP-EVV" wrote in message
...
I guess I got a little too excited at first....I've tried your suggestion
and
the lines are still there....they show up when the copy command is
executed
and don't go away after the paste command.....anyone have any other ideas
?

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