Include this in your code to see what actually has been selected and
hence would be copied:

MsgBox ActiveWindow.RangeSelection.Address


Hans