a more robust paste unformatted

J

J Heuer

As with many Excel users, one of the first macros I created (using the
recorder) was to paste unformatted text. However, when I try this with
anything that has a number in it, the macro fails (because a different
dialog box comes up). Is it possible to create a single macro that will
paste BOTH unformatted text AND (unformatted) values, depending on
what's being pasted?
 
B

Bob Greenblatt

As with many Excel users, one of the first macros I created (using the
recorder) was to paste unformatted text. However, when I try this with
anything that has a number in it, the macro fails (because a different
dialog box comes up). Is it possible to create a single macro that will
paste BOTH unformatted text AND (unformatted) values, depending on
what's being pasted?
Click to expand...
You'll have to provide some examples of what is happening or not happening.
What is the exact text that you are trying to paste, and how does it end up?
How did the text get on the clipboard?
 
Top