In this video I look at a couple of copy / paste problems that you might come across when you try to copy multiple ranges.

The first problem is where you get the error message "This action won't work on multiple selections". This error occurs when your second (or third etc) selection is not in the same rows or columns as you first selection. You also get this error when the second selection is not the same size as the first.

The second problem occurs when your copy range contains formulas. By default, when you copy multiple ranges, Excel pastes values instead of formulas. You can get around this by using Paste special.

Table of Contents:

00:00 - Introduction
00:10 - "This action won't work on multiple selections" error
02:30 - Doesn't copy formula
------------------------