Now I seem to have an additional problem.

What I am trying to do is copy a list of select personnel names and paste
their initials to a range of cells. This will occur over two separate
workbooks.

I thought I tested this, but when copying the cells all the cells from the
first cell to that last cell selected are copied to the clipboard, not just
the selected cells.

Ideally, I want to be able to mark specific names from a list, manually move
to a position in another workbook and then insert the initials from the
names. I thought going through the clipboard would be the easiest way for
the user to select the names.

I am guessing that when copying to the clipboard, the entire range is copied
but selected cells are marked somehow. Also included would be everything
from the Paste Special dialog (formatting, formulas, etc.).