Loop Does Not Stop

[ryanmorris]

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.

Please Login or Register  to view this content.

The data is sourced from a txt file so part of my macro imports the txt file and converts it from text to columns.

[Bob Phillips]

Maybe try

Please Login or Register  to view this content.

[barryleajo]

With acknowledgements to shg in 2008
http://www.excelforum.com/excel-prog...y-or-null.html

[ryanmorris]

Worked perfectly. Would you be able to explain why your code works but mine doesn't?

Thanks!!

[Whizbang]

IsEmpty works on a single cell, but not on multiple cells. I am not sure why, but I cannot get IsEmpty to return anything but false for multiple cells.

[snb]

or

Please Login or Register  to view this content.

[ryanmorris]

Can a Mod mark this thread as solved? I tried the same day that I made it but I do not have the edit option anywhere.

Thanks!

[Mordred]

You should PM a mod so that they know it needs to be done.

[Mordred]

I've posted this link so that Mods will see it.