Copy data from 1 excel sheet to another by cl [Closed]

puneet - Nov 28, 2011 at 10:40 PM - Latest reply: rizvisa1 4482 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen
- Nov 30, 2011 at 04:47 PM
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.
See more 

1 reply

rizvisa1 4482 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Nov 30, 2011 at 04:47 PM
0
Helpful
Worked for me. Do you get any error ?