Selecting a range using a column number reference
I know this code isn't correct, but it's what I've got so far.
Range((c + 2) & "2").Select
"c" is a variable in which was set in previous code using:
c = cell.Column
I'm trying to write the code so that it will select a range that will match
the column set by the variable (in this case is column 142 + 2, and row 2.
I believe this is somewhere around EL2. How can I change the code so that
it will select the range using the column number reference instead of the
letter reference?
Thanks,
Paul
|