In addition to Dave's comments................

You will also get the text and unicode options if you have copied to the Windows
clipboard and not the Office clipboard.

i.e. copy the text from this post and paste special to Excel will give you the
unicode, text options.


Gord Dibben MS Excel MVP

On Sat, 05 Jan 2008 15:23:18 -0600, Dave Peterson
wrote:

If you have two workbooks open in two different instances of excel, then you'll
see this "funny" paste special dialog.

Opening both the workbooks in one instance of excel will get your "normal" paste
special dialog back.

Without seeing the code that you used, I wouldn't guess at the second question.

And for the third question, you can close the workbook like:

someworkbook.close savechanges:=false 'or true

to avoid any prompt.

RHall wrote:

When using "Paste Special" sometimes I get the full selection menu and
sometimes I only get a choice for unicode or text. What determines which one
I get?
Also, when I "paste special" requesting "Values" in a recorded macro the
receiving worksheet moves columns to the right of my paste to the left. I
pasted in columns "A" & "B" and it moved a formula in column "H" to "F".
What's going on?
Also, when recording the macro it does not capture the "NO" to saving the
file when closing it. I don't want my user to have the option to save it
since the macro used a filter selection.
Thanks for any help. RHall
--
none