Adding rows

  • Thread starter Thread starter Squeaky
  • Start date Start date
S

Squeaky

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
 
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
 
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
 
Back
Top