i have used special paste before to transfer data from one cell in one
worksheet to a cell formed by 4 merged columns in another worksheet--using
copy-special paste-formula. Works like a charm. Now when i try to use
special paste i get a totally different dialog box with totally different
options. Instead of seeing All/formula/Values/formats....etc i see things
like Bitmap, biff, html, hyperlink.....etc HELP Where are the old options?

caraol49