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!