I have a file that generates an exception list. I have created a counter to
count the number of cells in a column that have a value. My question is how
do I select this range. The range variable is value.

Range("a1:f"value)