Hello, any thoughts on why the below macro is resulting in a runtime error 13? I am trying to concatenate the values in column N and DO with a "-" in the middle. If I remove the "-" it works..... just not sure why I cant put a "-" between the two values. I also tried without "" and it doesn't work either.
Sub Concatenate() Dim CalcMode As Long Dim ViewMode As Long Dim LastColumn As Integer Dim LastRow As Integer With Application .ScreenUpdating = False End With 'Select "Inventory Transaction Summary" worksheet, insert new column "Value less VAT", insert calculation (BMP*Q) With Sheets("Inventory Transaction Summary -") 'Improves speed of macro .Select ViewMode = ActiveWindow.View ActiveWindow.View = xlNormalView .DisplayPageBreaks = False 'Insert "Value less VAT" column heading after last column LastColumn = ActiveSheet.UsedRange.Columns.Count LastRow = ActiveSheet.UsedRange.Rows.Count ActiveSheet.Cells(1, LastColumn + 1) = "NSN Batch Number" Range(Cells(2, LastColumn + 1), Cells(LastRow, LastColumn + 1)).FormulaR1C1 = "=CONCATENATE(RC14," - ",RC119)" End With ActiveWindow.View = ViewMode With Application .ScreenUpdating = True End With End Sub