Hi,
I'm using the following code in VBA and want to have the formula populate down column S to the end of the data set. I'd like to use column A to determine my last cell with data in it. The formula will always begin in cell S7, however the S15 that I have in the code isn't always necessarily going to be the end of the data set. Any help would be greatly appreciated.
Thanks.
I'm using the following code in VBA and want to have the formula populate down column S to the end of the data set. I'd like to use column A to determine my last cell with data in it. The formula will always begin in cell S7, however the S15 that I have in the code isn't always necessarily going to be the end of the data set. Any help would be greatly appreciated.
Code:
Sub enter_formulas()
Range("S7:S15").Formula = "=CONCATENATE(AB7&""-""&T7&""-""&V7&""-""&AD7&""-""&AE7)"
End Sub
Thanks.