VBA Commands

[ds_robb]

Can anyone tell me a useful VBA command to copy the contents of one cell on one worksheet to another cell on another worksheet.

Am trying to copy cell A3 on a worksheet called Q2 to cell A5 on a worksheet called Entry.

Thanks

 

[brettvba]

Sub test()
Sheets("Entry").Range("a5").Value = _
Sheets("Sheet1").Range("a3").Value
End Sub

 

[smozgur]

Hi,

This will also copy formats beside cell value.

Worksheets("Q2").Range("A3").Copy Worksheets("Entry").Range("A5")

Regards
Suat