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

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,201
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,099,995
Messages
5,471,895
Members
406,791
Latest member
jbjohnson93

This Week's Hot Topics

Top