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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing columns in formula
Use the Cells property in combination with Resize to do what you want...
Cells(strRow, strCol).Resize(, 5).Select Although I'm willing to bet you don't actually need to select the range in order to do whatever it is you want to do to the range (you didn't tell us). By the way, strCol can either be the column number or column letter... the Cells property will tolerate both forms of specifying the column. -- Rick (MVP - Excel) "Bigfoot17" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing columns in formula
This should give you a few ideas:
Sub SelRange() Dim MyRng As Range Set r = Application.InputBox(prompt:="select range with mouse", Type:=8) r.Select If TypeOf Selection Is Range Then Set MyRng = Selection End If End Sub HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Bigfoot17" wrote: 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! |
Reply |
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 |