run a macro multiple times... Not functioning
Erich Shellhammer last edited by
I am able to record and run a macro I can repeat once without any issues, but if I tell it to run mutiple times by count, ot until EOF, it either does nothing, or simply ignores half of the macro.
Any help would be appreaciated.
Diane Grosshans last edited by
I have had the same problem. Only one line could be changed at a time.
I made the end of the line following the last populated field… no trailing spaces.
Now I run EOF or number of lines and it goes through the entire file, but only the first line is updated properly.
I am inserting spaces to create a space delimited text file to unload to CSV file.
Only the first record is converted properly.
It looks like each subsequent line has a space added in it that is not visible. Wonder if it is related to CR or LF at the end of each line.