| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding rows
This should be easy but is giving me grief.
I need code that, after selecting a random cell in column A ( I have the code to do that part) will then select the next 12 entire rows underneath it. Squeaky |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding rows
As ALWAYS, post your code for comments
activecell.resize(12).select -- Don Guillett Microsoft MVP Excel SalesAid Software "Squeaky" wrote in message ... This should be easy but is giving me grief. I need code that, after selecting a random cell in column A ( I have the code to do that part) will then select the next 12 entire rows underneath it. Squeaky |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding rows
If you mean *** entire *** row...from the active cell; try the below
Rows(activecell.row & ":" & activecell.row+12).select If this post helps click Yes --------------- Jacob Skaria "Squeaky" wrote: This should be easy but is giving me grief. I need code that, after selecting a random cell in column A ( I have the code to do that part) will then select the next 12 entire rows underneath it. Squeaky |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding rows
The wording of your request is not entirely clear to me. When you say "then
select 12 entire rows **underneath** it"... to you mean the 12 row below the active cell? If so... ActiveCell.EntireRow.Resize(12).Offset(1).Select If, on the other hand, you are requesting 12 entire rows *starting with* the active cell, then do this instead... ActiveCell.EntireRow.Resize(12).Select -- Rick (MVP - Excel) "Squeaky" wrote in message ... This should be easy but is giving me grief. I need code that, after selecting a random cell in column A ( I have the code to do that part) will then select the next 12 entire rows underneath it. Squeaky |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding rows
Thanks for all of the suggestions.
The one from Rick did the trick. Squeaky "Squeaky" wrote: This should be easy but is giving me grief. I need code that, after selecting a random cell in column A ( I have the code to do that part) will then select the next 12 entire rows underneath it. Squeaky |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding rows based on no of rows specified from a given position | Excel Worksheet Functions | |||
| adding some rows in the middle of adding some other rows | Excel Programming | |||
| Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
| Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
| Adding new rows | Excel Discussion (Misc queries) | |||
Linear Mode
