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!

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!

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!