I find that when parse data (text to cols), whenever I copy new data, Excel automatically parses to the previous parse format.
This creates real problems when I have to record or write VB code to handle a number of different sets. So far the only way I've gotten around this is to initiate another Excel process.
What's the trick to eliminating Excel-parse-dejavu?
Thanks,
FredK
This creates real problems when I have to record or write VB code to handle a number of different sets. So far the only way I've gotten around this is to initiate another Excel process.
What's the trick to eliminating Excel-parse-dejavu?
Thanks,
FredK