×

VBA Copy/Paste

Copy Each Excel Tab To Individual File or PDF (In Seconds!)

Copy Each Excel Tab To Individual File or PDF (In Seconds!)

Splitting Up Your Excel Sheets If you’ve come across this article, chances are you are looking for a solution that...

Best Way To Copy & Paste Special Values Only With VBA

Best Way To Copy & Paste Special Values Only With VBA

What This VBA Macro Code Does The following two examples of VBA code show you how you can automate copy...

Best Way To Paste Special Excel Objects As PowerPoint Images

Best Way To Paste Special Excel Objects As PowerPoint Images

Quality Matters I've written many times in the past on how the quality and formatting of your work can separate...

How To Use VBA Code To Copy Text To The Clipboard

How To Use VBA Code To Copy Text To The Clipboard

Update! Better Solution from ExcelHero Excel MVP Daniel Ferry from ExcelHero graciously provided a much more eloquent solution than my...

Copy & Paste Multiple Excel Tables Into Microsoft Word With VBA

Copy & Paste Multiple Excel Tables Into Microsoft Word With VBA

Moving Excel Tables Into Various Word Pages  This post is an add-on to a previous post I wrote covering how...

VBA Copy/Paste Multiple Excel Ranges To PowerPoint Slides

VBA Copy/Paste Multiple Excel Ranges To PowerPoint Slides

Stop Manually Copying and Pasting! This post is a continuation of the current most popular blog post on The Spreadsheet Guru...

VBA Copy/Paste An Image, Text, & Table (Excel to Word)

VBA Copy/Paste An Image, Text, & Table (Excel to Word)

Taking A Previous Post One Step Further This will build from a post I previously wrote entitled Copy & Paste An...

VBA To Copy/Paste Excel Table Into Microsoft Word

VBA To Copy/Paste Excel Table Into Microsoft Word

Moving An Excel Table Into A New Word Document In this post you will learn how to write VBA code...

Copy & Paste An Excel Range Into PowerPoint With VBA

Copy & Paste An Excel Range Into PowerPoint With VBA

Why Do This? I've received a large number of questions on how to command other programs with VBA through Excel....

Caution Writing PasteSpecial Macros

Caution Writing PasteSpecial Macros

What's The Story? One day I was teaching a co-worker how to create simple macros to use across any of...