|Since we can't see your spreadsheet from where we're sitting, we don't know what this means:|
but has a highlighted line through some of it
Can you explain that in some more detail?
Can you also explain what you mean by when its pasted its is missing certain cells.
Missing? In what way are they "missing"?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.