1-2.txt1-3.txt1-4.txt1-1.txt1-5.txtHello
I am trying to get excel to export a named row column 1, column2, and Column 3. column 3 is empty and used to create a blank line in the text file. the largest worksheet is 180 rows in length. The method I found that I have been able to use creates a macro of 2800 lines which creates an error because it is to long. So I am only able to create 40 text files at a time. hopefuly creating a range will be easier.
I need to figure out how to do this as a range A1, B1 and aline break then the next 8 ranges A2, B9 preferable with a line break(space between lines)
then the next .txt page range A2, B2 line break 8 ranges A1, B9
Basicly the problem is for each seperate text i need to set the ranges because they are different on each page
I have a small Working snippet of how I am currently exporting for review.
Any help would be greatly appriciated
Please Login or Register to view this content.
Bookmarks