Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Selection.EntireRow.Insert question

  1. #1
    Join Date
    8th May 2003
    Location
    the Med Sea
    Posts
    122
    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,677
    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

    Web Presence:
    Personal: Datasapien
    LinkedIn: Will Riley

  3. #3
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,314
    Hi Balangan,

    try,

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

    Cheers
    Andy

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    8th May 2003
    Location
    the Med Sea
    Posts
    122
    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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. EntireRow VS Row
    By econstantin in forum EXCEL HELP
    Replies: 6
    Last Post: January 7th, 2008, 23:10
  2. Delete Entirerow
    By jlibooth in forum EXCEL HELP
    Replies: 5
    Last Post: September 24th, 2006, 01:41
  3. Selection.Insert Shift:=xlToRight
    By tjolley in forum EXCEL HELP
    Replies: 2
    Last Post: June 10th, 2005, 01:20
  4. Insert Into statements question
    By Cro in forum Excel and/or SQL Help
    Replies: 4
    Last Post: January 22nd, 2005, 03:50

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno