Copy Worksheet cell values to clipboard

[ipbr21054]

Hi,
Please can you advise how i can copy worksheet cell values to the clipboard.
The cells in question will always be the same.
It is only the value that will change.
The value will in the cell will only ever be a letter or a number

The values i need to copy are in the following cells.

P6 = 9
Q6 = 8
R6 = 7
S6 = 6
T6 = 5
U6 = 4

So when i then paste elsewhere i should then "in this example above " be pasting 987654

Thanks.

 

[ipbr21054]

Hi,
Just an update.
The following works but need some advice.

.Range("P6:U6").Copy

The values on the worksheet have borders.
When the values are pasted elsewhere the borders are also pasted.
Please advise how i edit the code to just copy the value Without the border.

I have noticed that once i have pasted the value i see the cells in question are still selected,dancing ants around each cell.
How do i now edit the code to Un select the cells

I will then be completed fro this task.

Thanks

 

[ipbr21054]

I should say if it makes a difference that i am not pasting the value in Excel