Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I lost the highlight color when selecting a range, column or row. | Excel Discussion (Misc queries) | |||
Selecting the correct number from a range of cells | Excel Worksheet Functions | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
Selecting specific row/column from a named range | Excel Worksheet Functions | |||
reference to column (not known) and certain row number | Excel Programming |