Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing columns in formula
I started out selecting a range like this:
Range("B13:G13").Select Then I realized that I wanted to use a variable for the row instead of 13 and changed it to this: Range("B" & strRow & ":G" & strRow).Select Now I want to be able to use a variable for the column. I'd like to select "B" through the 5th column over ("G") or if my starting column is "I" then select through the 5th column over ("N"). Below is wrong, but what would be correct? Range(strCol & strRow & ":" & (strCol + 5) & strRow).Select Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Referencing Columns By Date | Excel Worksheet Functions | |||
Referencing columns as rows | Excel Discussion (Misc queries) | |||
Referencing Columns in a Row. PLEASE HELP!! | Excel Worksheet Functions | |||
I need to Sum multiple columns by referencing one formula | Excel Programming | |||
Referencing two columns for data | Excel Programming |