I tried the code (copied and pasted exactly as in spreadsheet) - but got a "run-time error '13': type mismatch"

Dim rangestart As String
Dim rangestop As String

rangestart = "H" + newRow_batchDetails
rangestop = "H" + latestbatchrow_batchDetails