Count down a certain number of rows?
 

I feel like there's a simple solution for this, but I can't think of it.

I need to select columns A:C starting at A7 and then select 10 down from there. So if I were to hardcode it, it would be from A7 to C16, but to make it dynamic, I just want to hardcode the A7:C7 and count down 10 rows to arrive at C16.

Range("A7:C7").Resize(10).Select


E.

Count down a certain number of rows?
 

It happens that KeriM formulated :
I feel like there's a simple solution for this, but I can't think of it.


I need to select columns A:C starting at A7 and then select 10 down from
there. So if I were to hardcode it, it would be from A7 to C16, but to
make it dynamic, I just want to hardcode the A7:C7 and count down 10
rows to arrive at C16.

Look at Resize...

Range("$A$7:$C$7").Resize(10)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Count down a certain number of rows?
 

hi,

Range("A7").Resize(10, 3).Select

--
isabelle


Le 2012-10-26 15:07, KeriM a écrit :
I feel like there's a simple solution for this, but I can't think of it.


I need to select columns A:C starting at A7 and then select 10 down from
there. So if I were to hardcode it, it would be from A7 to C16, but to
make it dynamic, I just want to hardcode the A7:C7 and count down 10
rows to arrive at C16.

Count down a certain number of rows?
 

isabelle explained :
hi,

Range("A7").Resize(10, 3).Select

--
isabelle


That's what I started to post but then I re-read and caught this...

"I just want to hardcode the A7:C7 and count down 10 rows.."

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Count down a certain number of rows?
 

i also hesitate between these two possibilities but .. this is just fine
like that, Kerim has the choice ;-)

--
isabelle

Le 2012-10-26 18:42, GS a écrit :
isabelle explained :
hi,

Range("A7").Resize(10, 3).Select

--
isabelle


That's what I started to post but then I re-read and caught this...

"I just want to hardcode the A7:C7 and count down 10 rows.."