Setting the paste format

[mtheriault2000]

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

 

[Andrew Poulsom]

Look here:

http://www.mrexcel.com/forum/showthread.php?t=40443

 

[mtheriault2000]

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