why don't buttons work?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Try something like this instead:
Sheets("SHIFTS").Range("A20:C28").Value = Sheets
("A3").Range("D1:F9").Value
 
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
 
You must log in or register to reply here.

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

i = row number of last occurance of duplicate string Column A 4
Copy Data from one sheet to many based on column A 7
[Q] How to create new worksheets based on an array (via named range) 4
Why recalculation does not start? 3
For Eachcell in Range tranpose comma seperated values to a list in D 4
Transfering 2D Array into 1D Array 2
Convert A1 value to a sheet name and copy to it 2
Sum number range ignoring numbers formatted as text 0

Back
Top