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.