Range as a variable
 

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)

Range as a variable
 

Range("a1:f" & value)
--
Gary''s Student - gsnu200772