View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Harvey Tom Harvey is offline
external usenet poster
 
Posts: 6
Default 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