How to de-select pasted cells?

I have a macro that inserts a line i a table:

1. insert a line just above the bottom line
2. offset one step down
3. copy bottom line from col. A to S
4. offset one step up
5. paste into the new next-bottom line

After this I want to delete the cells in the new line in column B, C and D. The problem is that after the pasting, all the newly pasted cells stay selected. Trying to select col. B, C and D only moves the complete selection three steps to the right so that upon deletion the complete contents are deleted.

How can I de-select the pasted values?
I sometimes use Application.CutCopyMode = False, but it does't work here.

Please Login or Register  to view this content.

/NSV

More specifically I need to copy the cells in the A-, in the E- and in the H to S columns.

Thanks for the tips. I've seen before that one should avoid to select, but my knowledge about VBA comes from analyzing the recorded code, so it is a bit difficult to optimize anything.