Jackel
03-14-2017, 11:58 AM
Hello all,
I am trying to build a quick and easy macro that inserts a custom concatenate formula, then selects down to the last row (usually 3-7 rows). I have the correct formula, but just cant get the ranges to work. Some help would be greatly appreciated if this is possible!!
ActiveCell.FormulaR1C1 = "=myconcatenate(R[7]C:R[1]C)"
I am trying to build a quick and easy macro that inserts a custom concatenate formula, then selects down to the last row (usually 3-7 rows). I have the correct formula, but just cant get the ranges to work. Some help would be greatly appreciated if this is possible!!
ActiveCell.FormulaR1C1 = "=myconcatenate(R[7]C:R[1]C)"