No sample file + vague explanation = confused. But, maybe:
Option Explicit Sub Inbox() Dim GetRng As Variant GetRng = InputBox("enter first and last separated by comma") GetRng = Split(GetRng, ",") 'Looping the through each row For i = GetRng(0) To GetRng(1) '... End Sub
Bookmarks