I'm trying to create a text file for upload into another application from “sheet1” in Excel 97. If I have any blank lines on the text file, I get an error on the upload in the other application. I have a formula that is combining the data from three columns on "sheet1" to one column on "sheet2". The problem is the number of rows will be different each time I run the copy macro. What I'd like to put in the macro is something that copies the formula in cell A1 on "sheet1" to cells A2:A(x) where x is 1 minus the number of rows in "sheet2".<br>
<br>
What I've tried is having my formula in rows 1 through 1000 on “sheet1”, had the macro set the cell in "sheet1" to Null if the corresponding cell in "sheet2" is Null. Then had the macro do a copy paste special formulas as values. But when I create the text file, all the rows that are empty are on text file as blank lines.<br>
<br>
What I've tried is having my formula in rows 1 through 1000 on “sheet1”, had the macro set the cell in "sheet1" to Null if the corresponding cell in "sheet2" is Null. Then had the macro do a copy paste special formulas as values. But when I create the text file, all the rows that are empty are on text file as blank lines.<br>