Copy data from 1 excel sheet to another by cl

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Worked for me. Do you get any error ?