Premium Only Content

Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)
April 19, 2018 Excel VBA & Macros Tutorials
Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/
This tutorial shows you how you can copy and paste with VBA. We use the copy method as well as the pastespecial method.
The copy method in VBA, copies data, as well as formatting, formulas, comments etc - with the pastespecial method, you have more control over your paste options. For example, you can paste formatting only - or choose to paste values as well as number formatting.
I also show you how to use the resize property, so you can change the size of the current region before you copy. This is good for cases where you want to copy the data but exclude the header. Here we add in OFFSET as well.
➹ ➹ Excel VBA Course ➹ ➹
This Excel VBA tutorial for beginners, is part of my "Unlock Excel VBA and Macros" course. Get it here: https://courses.xelplus.com/p/excel-vba-excel-macros
🡻 Download the workbook here 🡻
http://www.xelplus.com/vba-copy-paste/
★★ Links to related videos: ★★
Referencing Ranges with VBA: https://rumble.com/v2u2ofm
Learn about Visual Basic Editor: https://rumble.com/v2tv4va
Recording macros: https://rumble.com/v2tv4ui
Properties & methods in VBA: https://rumble.com/v2tv4wg
★ My Online Excel Courses ★
Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
LIVE
Game On!
16 hours agoRIP to the LEGENDARY Hulk Hogan!
7,797 watching -
1:44:38
Nick Freitas
15 hours agoHave Republicans Already Won 2026?
25K10 -
LIVE
The Bubba Army
22 hours agoHulk Hogan Dead at 71 | Bubba the Love Sponge® Show | 7/25/2025
4,353 watching -
23:48
Jasmin Laine
16 hours ago“CHRISTIANS Are a Threat” Musician BANNED From Canada for MAGA Beliefs
3.11K21 -
LIVE
BEK TV
23 hours agoTrent Loos in the Morning 7/25/2025
375 watching -
15:03
Dad Saves America
13 hours ago $1.41 earnedHow the Department of Education Hijacked Our Schools - Poisoning of the American Mind: Pt 3
26.7K5 -
14:06
Silver Dragons
15 hours agoBullion Dealer Reacts to Silver Price TRIPLING in 5 Years
11.5K4 -
28:31
Anthony Rogers
14 hours agoBOWLING FOR SOUP interview
9.04K3 -
17:12
Nate The Lawyer
2 days ago $2.19 earnedTrans Swimmer Lia Thomas Stripped of Titles for Being a Man in Women’s Sports
28.5K24 -
12:17
Zoufry
20 hours agoThe Hunt For The Real Life James Bond
34.7K6