Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over.
From active cell, select the next 10 rows down, 6 columns over.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over.
Range(Cells(activecell.Row,activecell.Column),
Cells(activecell.Row+10,activecell.Column+6)).sele ct If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: From active cell, select the next 10 rows down, 6 columns over. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over.
Range(Cells(activecell.Row,activecell.Column),
Cells(activecell.Row+10,activecell.Column+6)).sele ct -- If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: From active cell, select the next 10 rows down, 6 columns over. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over.
Mr. Jacob, that didn't work...
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over.
It is not entirely clear from your question whether you want the
ActiveCell's row and column included in the new selection or not. If you want them included... ActiveCell.Resize(11, 7).Select Note the 11 and 7 are your 10 and 6 plus one each. If you don't want them included... ActiveCell.Offset(1, 1).Resize(10, 6).Select In any event... the Offset and Resize properties are the one's you will want to play with. -- Rick (MVP - Excel) "J.W. Aldridge" wrote in message ... From active cell, select the next 10 rows down, 6 columns over. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over.
thanx...
wanted to select the entire range, so the first one worked. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over
Try this.....it was too long...
Range(Cells(ActiveCell.Row, ActiveCell.Column), _ Cells(ActiveCell.Row + 10, ActiveCell.Column + 6)).Select If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: Mr. Jacob, that didn't work... |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over
This is much easier to do using the Resize property of the Range object (the
ActiveCell in this case)... ActiveCell.Resize(11, 7).Select where the 11 and 7 are one more than the number of rows and columns to add (the one being so that the 10 and 6 are in addition to the ActiveCell's row and column). -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... Try this.....it was too long... Range(Cells(ActiveCell.Row, ActiveCell.Column), _ Cells(ActiveCell.Row + 10, ActiveCell.Column + 6)).Select If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: Mr. Jacob, that didn't work... |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
From active cell, select the next 10 rows down, 6 columns over
Thanks Rick..
If this post helps click Yes --------------- Jacob Skaria "Rick Rothstein" wrote: This is much easier to do using the Resize property of the Range object (the ActiveCell in this case)... ActiveCell.Resize(11, 7).Select where the 11 and 7 are one more than the number of rows and columns to add (the one being so that the 10 and 6 are in addition to the ActiveCell's row and column). -- Rick (MVP - Excel) "Jacob Skaria" wrote in message ... Try this.....it was too long... Range(Cells(ActiveCell.Row, ActiveCell.Column), _ Cells(ActiveCell.Row + 10, ActiveCell.Column + 6)).Select If this post helps click Yes --------------- Jacob Skaria "J.W. Aldridge" wrote: Mr. Jacob, that didn't work... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
How select active rows from A to D columns? | Excel Discussion (Misc queries) | |||
Select columns of active cell's row | Excel Programming | |||
Select Row of Active Cell | Excel Programming | |||
Select a range of columns based on active cell | Excel Programming |