thanks, it did work when those values started in the 12th columns as listed in the code above. What about if the start in the 11th or 10th or 9th or 8th or 20th or 25th so on and so forth. Can we set the 12 to a dynamic value, because it did not work for values that started in column G or Column H. It only worked for values that started in column E and column L. I have code to extract the first pre-money value. What if we look at the premoney value which will be in column A and then find it in the row and sum the range after it?