Hi Friend,

You can make calculation Manual and past or write values in worksheet.
by the following vba code

Application .Calculation = xlManual
Application.ScreenUpdating = False

after your data complete set back to normal by following code

Application .Calculation = xlAutomatic
Application.ScreenUpdating = True

I hope you enjoy this.

Take care
S.Suresh

Bye by

--
s_u_res
-----------------------------------------------------------------------
s_u_resh's Profile: http://www.excelforum.com/member.php...fo&userid=1567
View this thread: http://www.excelforum.com/showthread.php?threadid=27241