macros

What is the macro command to go down to the next line?

Jerry

There are several ways

ActiveCell.Offset(1,0).Select

Is just one

Hi All,

 There is something that pop-out in my mind in his question...

What if I want to insert row with a requirement that below the each subtotal is inserted 2 rows without identifying the location of the row.

Example:

Range("A5:S63").Select
    Selection.Subtotal GroupBy:=5, Function:=xlSum, TotalList:=Array(8, 9, 10, 11, _
        12, 13, 14, 15, 16, 17, 18, 19), Replace:=True, PageBreaks:= _
        False, SummaryBelowData:=True

There is subtotal as reference for Group 5. How can I insert 2 row for each subtotal?

Does it make sense?

Big Thanks.

Blue