how to copy just values.

[vash1628]

i'm working on a spreadsheet and am trying to find code to copy just the value to a cell from another sheet in the same work book. i have 2 codes but i'm trying to find a way to do it in the background without the cells being selected.
the first code that does what i want is :

Please Login or Register  to view this content.

the scroll is to get back to the top of the safety sheet.
the other code i have been trying is

Please Login or Register  to view this content.

So what i would like it to do is in cell E56 on the Safety sheet copy the date ( and just the date, no formats etc) from B4 on the Inputs sheet. Both my codes use a formula to copy the cell e.g. (=Inputs!B4)I then have to copy and paste special over the cell to leave just the value and not the formula.
I prefer the way the second code puts in the formulas as no cells get selected and page does not auto scroll or open and close on that sheet. i'm attaching the work book.
I have tried using a value command but that was not accepted . I'm assuming my use of it was incorrect.

also in the sub attend:

Please Login or Register  to view this content.

is the only way i can stop it from changing the tick marks to A's when run again by changing the starting values? For example p will change the letter to an a and change the font to webdings. while A will change font to areal and make it red. but if you run it again it changes all the ticks to Big red A's.

[martindwilson]

try like this

Please Login or Register  to view this content.

[vash1628]

thank you just what i needed