|I assume that by "multiple cells" you mean noncontiguous multiple cells - i.e. cells that do not border each other. As you have found, Excel will not allow you to do that.|
Here is one way around it:
Here is a "oddity" that details situations where it actually does work.
Google the issue for more hits.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.