hi all, the code below runs well, but wanted to see if i could omit the "range(K16:q1000)" part of the code.
in every instance i need to select K16 first and then to the last row of column Q. minus one row if possible
i tried rows.count -2,1 but i imagine this just goes to row 998...