ermccarthy
Board Regular
- Joined
- Feb 15, 2002
- Messages
- 224
I have a macro that uploads a .prn file into my workbook, and then formulas run off of that uploaded data. My problem is sometimes the text file puts in page breaks which appear as small rectangles after the number (at the end of a line). With those there, my formulas do not work. Is there anyway to make these go away either with a command in the macro during the upload process, or by running a macro to "search and destroy" these pesky little boxes....(PS the boxes are always there in the file, but sometimes that fall in areas that don't bother me, like after a label, so they are not always in the same place)
Any ideas??
_________________
Russell
This message was edited by ermccarthy on 2002-02-21 11:06
Any ideas??
_________________
Russell
This message was edited by ermccarthy on 2002-02-21 11:06