Announcement

Collapse
No announcement yet.

Selection.EntireRow.Insert question

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Selection.EntireRow.Insert question



    Selection.EntireRow.Insert

    This command will add an entire row before the selected row. How can I change this command to instead add it below?
    (I really need this done this way, no workarounds)

    Thanks!

    Balangan
    Best,

    Balangan

  • #2
    select the row below the one you've already selected.

    i.e. instead of

    Range("A4").select
    Selection.EntireRow.Insert


    use
    Range("A4").Offset(1, 0).Select
    Selection.EntireRow.Insert

    hope this helps
    Kind Regards, Will Riley

    LinkedIn: Will Riley

    Comment


    • #3
      Hi Balangan,

      try,

      Selection.offset(1,0).EntireRow.Insert

      Cheers
      Andy

      Cheers
      Andy

      Comment


      • #4


        Originally posted by WillR
        select the row below the one you've already selected.

        i.e. instead of

        Range("A4").select
        Selection.EntireRow.Insert


        use
        Range("A4").Offset(1, 0).Select
        Selection.EntireRow.Insert

        hope this helps
        Hi Willr
        that unfortunately wont because the row below has got a different format, and the new row needs to be formatted like the row above. Thanks anyway
        Best,

        Balangan

        Comment

        Working...
        X