Trouble copy pasting value from one cell to the next.

[omairhe]

Hey,

I am simply trying to copy value from cell B2 and paste it into cell B3 but am unable to do so. could someone please guide me as the what needs to be changed in the following vba script?

 Range(B2).Value = Range(B3).Value

Thanks. will appreciate any help.

 

[Fluff]

You've got them the wrong way round

 

[omairhe]

You've got them the wrong way round

after making amendments getting a Run time error 1004
Method Range of object gloabl failed.

 

[Fluff]

You're also missing the quotes around B2 & B3

 

[omairhe]

Sub test()
 Range(B3).Value = Range(B2).Value
End Sub

 

[omairhe]

You're also missing the quotes around B2 & B3

ok cool. now it works after quotes. thanks again.

 

[Fluff]

You're welcome & thanks for the feedback