How can I use variable row numbers for Row("14:16").Select

[stevenwang78]

Hi,

I want to use variables to replace the specific numbers in selecting a range, e.g.

I = 15
J = 20
' How to define the rows from 15 to 20?

Thanks,

Steven

 

[SkipVought]

Steven,

All kinds of ways to skin a cat.

i=15
j=20
c=1
'Cells(row, col) is syntax - I prefer this one
With Range(Cells(i, c), Cells(j, c)).entirerow
   'do stuff to this range

end with
[code]
or
[code]
i=15
j=20
With Rows(i & ":" & j)
   'do stuff to this range

End with

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[dc20]

In addition to Skip's answer, here's ref to a similar question

http://www.tek-tips.com/viewthread.cfm?SQID=740966&SPID=707&newpid=707&page=1

Dave.

 

[DrBowes]

I would go for:

with range(rows(i),rows(j))


no concatenating strings and less dots therefore faster.