Hi AKM1,

I believe the contents of your windows clipboard determine what Paste Special Dialog you get. If you copy a Picture from Paint into the clipboard and then try to Paste Special into Excel you will get your first picture. If you copy cells out of Excel and try to Paste special into other cells you will get your second picture.

The short answer is - Paste Special knows what type of stuff in in the windows clipboard and will give you the appropriate dialog box to paste with.