Copy value not format?

[Destroy]

Sheet1.Range("B" & i + 1).Copy Sheet2.Range("B" & (cellsh2 + 3)).value

This above does not work. "Copy method of Range class failed". Why? What is proper syntax suppose to be?

Thanks.

[mehmetcik]

Sheets("sheet3").Range("A1:A3").Copy Destination:=Sheets("sheet2").Range("A1:A3)

[Destroy]

Sheets("sheet3").Range("A1:A3").Copy Destination:=Sheets("sheet2").Range("A1:A3)

I should of been more clear in my topic. I do NOT want the cell format(no color, no size, etc), only want the value.

[AB33]

An error

Sheets("sheet3").Range("A1:A3").Copy Destination:=Sheets("sheet2").Range("A1:A3)

[kosherboy]

Why don't you record your action?

[AB33]

Sheets("sheet3").Range("A1:A3").Copy
Sheets("sheet2").Range("A1").PasteSpecial xlValues

[Destroy]

Sheets("sheet3").Range("A1:A3").Copy
Sheets("sheet2").Range("A1").PasteSpecial xlValues

This above appears to work but interesting that this below does not.

Sheets("sheet3").Range("A1:A3").Copy Sheets("sheet2").Range("A1").PasteSpecial xlValues

[AB33]

Sheets("sheet3").Range("A1:A3").Copy Sheets("sheet2").Range("A1").PasteSpecial xlValues

copy and past special should be on separate lines (Should not on a single line) , otherwise, you get an error.

[Destroy]

copy and past special should be on separate lines (Should not on a single line) , otherwise, you get an error.

Yeah, I noticed that. Oh well.

thanks all.

Btw, don't record cause my complete macro is much more in depth and complicated. I only posted the bit that was giving me issue.