Good afternoon Ceemo

Excel will, to a degree, perform copying from a multiple selection –
that is where ctrl is held down while the user selects different areas
of the spreadsheet.  In some cases the user will receive the error
message  “That command cannot be used on multiple selections”.
However, if the selection to be copied includes the same cells from a
number of rows (eg. A1:A4 and C1:C4), or the same cells from a number
of columns (eg. A1:C1 and A4:C4), then it will work – but with two
peculiar side effects :  any formulae copied will be pasted as values,
and any spaces included in the selection will disappear.  This does not
appear to be documented in the help files.

However, I have a free add-in available upon request that will, amongst
other things, copy and paste multile ranges (across workbooks if
required) which has none of the above side effects.  If you require
this, please e-mail me.

Regards

DominicB
dominic@dom-and-lis.co.uk