Refer to column in range statement
 

Hi. How can I refer to the column in a range statement? For instance, the
column could be "AO" and I can get the column number, but I don't know how to
refer to it in the following Range statement. Note that the column will
change. I do have a variable called "ColNum"

Range("B1:AO4")

Thanks,
Mike.

Refer to column in range statement
 

Range("B1",.cells(4,colnum))

would be one way.

Mike D. wrote:

Hi. How can I refer to the column in a range statement? For instance, the
column could be "AO" and I can get the column number, but I don't know how to
refer to it in the following Range statement. Note that the column will
change. I do have a variable called "ColNum"

Range("B1:AO4")

Thanks,
Mike.

--

Dave Peterson