Copy data from 1 excel sheet to another by cl

Hello,

i am trying to copy data from 1 excel sheet to another by clicking on button. my code is:

Sub Button4_Click()
Worksheets("ManHour").Range("B6:B10").Value = Worksheets("Master_MH").Range("B6:B10")
End Sub

but it's not working.

but when i trying to copy only single cell it's working.


Sub Button4_Click()
Worksheets("ManHour").Range("B6").Value = Worksheets("Master_MH").Range("B6")
End Sub

Please help me.