Thanks Jim, I tried that (still have it commented out) but now it works like
a charm. BTW: Do you know how to echo out to the msg window the Range whch
will be used? I tried the following but doesn't seem to work:

MsgBox "The selected Range is " & rng.Text

Thanks again.

"Jim Thomlinson" wrote:

On the up side you are really close... Try this...

Set rng = Range(Cells(2, colNum), Cells(2, colNum).End(xlDown))
--
HTH...

Jim Thomlinson


"DJS" wrote:

Hello, I am trying to set Range dynamically with a variable and just can't
seem to figure out the proper method. Any help greatly appreciated. Plus, if
someone knows a great tutorial on how to use Range, Cells, etc that would be
appreciated also!

Here is my code snippet which does not seem to properly define the range
(Note: My var, colNum, is properly populating the column number field):

Set rng = Range(Range(Cells(2, colNum)), Range(Cells(2, colNum)).End(xlDown))

TIA