När jag tar bort de två feta raderna nedan, ser jag att det skapats en tom rad med ett värde i kolumn R, och jag har 1 rad mer än jag valt att den ska titta på.
Var i denna koden skapas den?
Sub writeXtimes()
Dim ReadFromSh As Worksheet: Set ReadFromSh = ThisWorkbook.Sheets("Journey SWE")
Dim lRow As Long: lRow = Cells(Rows.Count, 1).End(xlUp).Row
Dim Rng As Range: Set Rng = ReadFromSh.Range("T1:T" & lRow) 'Hämtar datan i kolumn T
Dim vnt As Variant: vnt = Rng
Dim PrintToSH As Worksheet: Set PrintToSH = ThisWorkbook.Sheets("Cycle sheet")
PrintToSH.UsedRange.ClearContents
Dim i, k: k = 1
For i = 1 To UBound(vnt, 1)
PrintToSH.Range("A" & k & ":Q" & (vnt(i, 1) + k)).value = ReadFromSh.Range("A" & i & ":Q" & i).value
k = k + vnt(i, 1)
Next i
Dim newRng As Range: Set newRng = PrintToSH.Range("A1:T" & k) 'Hämtar datan i kolumn T
Call RndRng(newRng, PrintToSH)
End Sub
Function RndRng(Rng As Range, ws As Worksheet)
Dim rngUpper As Long
Dim myRow As Long
rngUpper = Rng.Rows.Count
For myRow = 1 To rngUpper
ws.Cells(myRow, 18).value = Int((rngUpper * 10 - 1 + 1) * Rnd + 1)
Next myRow
Rng.Sort Key1:=ws.Range("R1"), Order1:=xlAscending, Header:=xlNo
Rng.Columns(18).ClearContents
End Function