Setting the paste format

mtheriault2000

Well-known Member
Joined
Oct 23, 2008
Messages
826
Hello to all

Another intriguing question for me

I got a strings formated like "/Forex/EURUSD/Buy/37000"

"/" is use as a delimiter for it.

When i choose paste the clipboard data, the string is automatiquely divided using the "Selection.TextToColumns" method, Even if i did not use the command.

In a word, Paste command remember the last paste format and use it.

So my question is, how do i tell Excel Vba, witch paste format to use???? I don't want to use the last used one.

Hope i'm clear enough.

Martin
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

mtheriault2000

Well-known Member
Joined
Oct 23, 2008
Messages
826
Hello Andrew

Yes the post will resolve my question.

Have to go for hte moment, but i'm sure this will be resolve soon after my return

Martin
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,480
Members
414,143
Latest member
lonnie451

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top