Trouble copy pasting value from one cell to the next.

omairhe

Well-known Member
Joined
Mar 26, 2009
Messages
1,835
Office Version
  1. 2019
Platform
  1. Windows
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?

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

Thanks. will appreciate any help.
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,077
Office Version
  1. 365
Platform
  1. Windows
You've got them the wrong way round ;)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,077
Office Version
  1. 365
Platform
  1. Windows
You're also missing the quotes around B2 & B3
 

omairhe

Well-known Member
Joined
Mar 26, 2009
Messages
1,835
Office Version
  1. 2019
Platform
  1. Windows

ADVERTISEMENT

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,077
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,902
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top