Count down a certain number of rows?

[KeriM]

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 fro
there. So if I were to hardcode it, it would be from A7 to C16, but t
make it dynamic, I just want to hardcode the A7:C7 and count down 1
rows to arrive at C16

 

[plinius-et]

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 fro
there. So if I were to hardcode it, it would be from A7 to C16, but t
make it dynamic, I just want to hardcode the A7:C7 and count down 1
rows to arrive at C16

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

E

 

[GS]

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

 

[isabelle]

hi,

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

 

[GS]

isabelle explained :

hi,

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

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

 

[isabelle]

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