keeping borders after pasting

hi guys

probably an easy one for most of you but i cant work it out

i have a cell with a border round the left,top and right edge

and everytime i paste something into that cell it removes the border so i have to manually do it again

is there any way i can stop having to do this

so that when i copy into the cell it stays exactly as it was before but with what ever i have copied into the cell also

many thanks

Thanks For That Vba Noob
Works A Treat

Rather Than Having To Do That Manually Everytime

Is It Possible That Excel Will Do It For Me

So If I Copy A Cell On Sheet 3 And Then Go To A Cell In Sheet 1

It Will Automatically Realise That I Want To Paste The Value???

Many Thanks

hey thanks vba

quality stuff as ever

many many thanks