My workbook as 2 worksheets, codenames are Data and Input.
In Input, I have some cell references, such as:
A1
A2
A10
The code below looks at the cells in the worksheet Data.
Dim CheckRng As Range
With Input
Set CheckRng = .Range(.Cells(1, 6), .Cells(10, 6))...