Automatically look for information on the next cell

[Mr_K]

Good day,

I have a macro based on a specific length of data. The problem is the length is not always fixed on the information I run it on (The number of rows flactuates).

How can I edit my macro to always stop only before an empty cell.

Thanks,

 

[SteveO59L]

You might have more success, if you post your existing code.