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
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