Copying a row to another spreadsheet

[Howard Brazee]

How do I make sure I'm not creating a link, when I copy a row from one
of two versions of a spreadsheet to another?

I wanted to copy some new data to a backup of my old spreadsheet. I
renamed the backup, cut some data from rows of my new spreadsheet to
my backup, then I closed them both, renamed the backup back, and
copied the backup over the original. But I got a link that I had to
search for to eliminate.

My version of Excel is a newer one where I can't find anything in the
menus, including the version of Excel.

--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison

 

[arjen van der wal]

I would think you'd just need to Copy Paste Special values instead of
Copy Paste.

Something like:
Range("D6").Copy
Range("G6").PasteSpecial Paste:=xlPasteValues