Simple copy and paste macro

**hernancrespo** · 11-08-2012, 06:29 AM

Alas! no

I get this error?

111111.JPG

"Run-time error "1004"

copy method of range class failed"

When I click Debug it highlights the whole line

**WasWodge** · 11-08-2012, 06:56 AM

Which sheet is the cell A2 that you are referencing on and what is the name of the sheet you are copying from?

**hernancrespo** · 11-08-2012, 07:01 AM

Hi WasWodge,

The sheet I am trying to reference from is called "Diary" and the the reference is on this sheet

So "A2" is on the "Diary" Sheet

Thanks in advance

Jon

**WasWodge** · 11-08-2012, 07:04 AM

Try

Sub CopyMe()
Sheets("Diary").Range("A1").Copy Destination:=Sheets("Week 1").Range("D" & Sheets("Diary").Range("A2").Value)
End Sub

**hernancrespo** · 11-08-2012, 07:30 AM

Hi WasWodge,

Unfortunately I am getting a different error message-

"Run-time error "1004"
Application defined or object defined error"

Thanks for you efforts though!

I'm sure there is a simple solution, but can't for the life of me figure out what it is!

**Sindhus** · 11-08-2012, 07:35 AM

Can you upload your workbook?

**hernancrespo** · 11-08-2012, 07:50 AM

Hi Guys,

I have had to heavily strip this workbook down- but hopefully it will show you what I am intending to do

I want to take what is written in cell B7

and cut and paste it in Week 1 in the same position in the diary- so in theory I can fill the diary for the day and then press a button linked to this macro which will copy and paste it in the relevant diary. And then run a macro which will show what is written in that cell. So in effect making a Two way cell.

The reason that the value has to be variable is that I will do a look-up up on the cell reference for each different contractor- which will be selected by the user.

my theory makes sense in my head! apologies if this is a mad mans scrawlings!

thanks

hernanMonth Diary Strip.xls