Hi I need help with a code:
I have a table with 11 columns and a variable number of rows. I need to start adding the values starting from the last row of fourth column (sum(range(lastrow:lastrrow)) and compare with a fixed cell. If the sum is larger, then select the entire table row (lastrow-1 to lastrow: 11 columns), if it is not, sum lastrow with lastrow - 1 and compare again. If the sum is larger, then select (lastrow-1 to lastrow: 11 columns), and then successively, until it finds a sum that is larger that fixed cell.
I am sure it is somethig easy but I can't get to it.
Thanks in advance
I have a table with 11 columns and a variable number of rows. I need to start adding the values starting from the last row of fourth column (sum(range(lastrow:lastrrow)) and compare with a fixed cell. If the sum is larger, then select the entire table row (lastrow-1 to lastrow: 11 columns), if it is not, sum lastrow with lastrow - 1 and compare again. If the sum is larger, then select (lastrow-1 to lastrow: 11 columns), and then successively, until it finds a sum that is larger that fixed cell.
I am sure it is somethig easy but I can't get to it.
Thanks in advance