Set a range to an entire column with index number
<p>I'm building a function that takes a column number as an input to return the highest value in the column.</p>

<p>I need to work with an entire column with a column index number. The following code works but I need an index number instead of using "B:B" to reference the column.</p>

<pre><code>Set rng = Range("B:B")
</code></pre>

<p>When I use the following code, everything seems to break down. It always returns a 0 even though the highest number is 44. Can you see what I am doing wrong? It worked perfectly when I used "B:B" as a range.</p>

<pre><code>Set rng = Range(Columns(2),Columns(2))
</code></pre>

<p>It doesn't seem to recognize anything in the range. Any help would be awesome!</p>