title: How to select cells in a row with EXCEL VBA until a cell with a certain value?
body: <p>I jus want to select consequent cells in a single row, until a certain cell, with the value "Total" in it. How do I do this in VBA? I'm making a VBA procedure which relies on the length of the row, which must be dynamic (the length can change).</p>