Yes. I've declared x as an integer. I'm looking to use x as a variable, not
a range. I need x to be a number. I need to count the cells in the range
and that number needs to be x. Sorry i wasn't more specific

"Johnny" wrote:

Did you dimension x?


Sub Foo()
Dim x as Range

Set x = Range("RangeNameHere")

With x
'Do stuff
end With

Set x = Nothing
End Sub