| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting delimiters for pasted data
Hello,
I have a macro that includes a text to columns operation using space as the delimiter. After running the macro, when I paste more data into an Excel spreadsheet space is still being used as the delimiter until I shut down and re-launch Excel. Is there a statement that I can add to my macro that would reset the delimiter for pasted data to tab? TIA, Tom |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup pasted data | Excel Discussion (Misc queries) | |||
| Help! data from pasted table is not included in sum | Excel Worksheet Functions | |||
| Parse data with uneven lengths and different delimiters | Excel Worksheet Functions | |||
| Validating data pasted into worksheet | Excel Discussion (Misc queries) | |||
| Extracting data with delimiters | Excel Programming | |||
Threaded Mode
