| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
Quote:
E. Last edited by plinius-et : October 26th 12 at 10:47 PM |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.." |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Number of Rows | Excel Worksheet Functions | |||
| COUNT NUMBER OF ROWS | Excel Worksheet Functions | |||
| Count how many Rows ago a particular number was hit | Excel Worksheet Functions | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
| Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
Hybrid Mode
