hi Ted,
Many thanks for your reply. It was my fault for not have mark this thread solved. My primary question was answered so I moved my question to another thread. You may find the continuation here : http://vbaexpress.com/forum/showthread.php?t=11039


Now, my answer to your question. Not exactly. My main objective is to paste the new formatting in line 144. Thereafter, paste the values I've got from the userform to line 144.

In short, mixer 3503 will be in cell A144, 20 will be in cell B144, and 20.035m will be in cell m144. The whole range will be paste from 144 to 155.

Hope this is clear enough. thanks so much for replying!