Hello all,
I have a piece of code for a Do While loop that does not stop. It is entering formulas in every cell that is in a row containing data. I want it to stop entering formulas when it reaches a row that has nothing in it. The loop works perfectly except that it will not stop at the last row of data, it continues to row 65,535 or so.
The data is sourced from a txt file so part of my macro imports the txt file and converts it from text to columns.Please Login or Register to view this content.
Bookmarks