why don't buttons work?

M

Mike

Try something like this instead:
Sheets("SHIFTS").Range("A20:C28").Value = Sheets
("A3").Range("D1:F9").Value
 
S

steve

Just to add. On the destination - you only need to specify a single cell.
This avoids the problem of matching areas.

Sheets("SHIFTS").Range("A20:C28").Value = _
Sheets("A3").Range("D1").Value

steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

For Eachcell in Range tranpose comma seperated values to a list in D 4
Simple Copy to and From Cells With IF statement. 3
Value from one sheet paste under same value on other sheet. 7
[Q] How to create new worksheets based on an array (via named range) 4
Convert A1 value to a sheet name and copy to it 2
Array to Multiple Arrays 3
Copy Array to Array, how to and should I? 13
Why recalculation does not start? 3

Top