View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 168
Default 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