Hello,

My problem is that I will select data in one sheet or workbook, copy it,
then select "paste special" to paste with a specific format (e.g. keep column
widths, values only etc.) into a new sheet; when I try to "paste special"
into the new sheet, the data is somehow read as a Worksheet Object, and my
choices are Picture, Bitmap etc. How can I fix this? Thanks very much in
advance for your advice.

Alyssa