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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Paste Special - Unformatted Text" Macro 3
Create a button for Edit/paste Special/Unformatted text ? 2
Macro for Pasting unformatted text 11
Simple Paste Macro Problem 1
Macro for Paste Special Unformatted Text 14
Paste unformatted text 9
problem creating a Word paste special macro 1
Paste Unformatted Text Macro Button 1

Top