Copy / Paste VBA

Glasgowsmile

Board Regular
Joined
Apr 14, 2018
Messages
126
Hello!

I wanted to create a button that would copy a specific set of cells and paste in a specific location when clicked.

I need it to copy B21:AC64 and paste it in B5 - on the same sheet.

What's that code look like?
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
39,164
Office Version
365
Platform
Windows
How about
Code:
Sub Glasgowsmile()
   Range("B21:AC64").Copy Range("B5")
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,096,444
Messages
5,450,488
Members
405,614
Latest member
SJ789

This Week's Hot Topics

Top