I've got a macro that was generously created by a user on this forum. I've been using it in another sheet, and ported it to a new one I'm using.
Basically I want to export a specific tab, but as the file can have 5 rows or 5000 (max 10,000) I want it to clear any blank lines so when I import the file into our POS it won't try and import a bunch of blank lines.
Anyhow, with this formula now I'm getting an error opening the file (what has 8 rows I think) that it exceeds the 1 million lines error. Can anyone view the code and see if its possible to mod it better to remove all blank lines?
Thanks!
Please Login or Register to view this content.
Bookmarks