+ Reply to Thread
Results 1 to 5 of 5

Delete two rows after offsetting first row

  1. #1
    Registered User
    Join Date
    12-08-2016
    Location
    Rotterdam, the Netherlands
    MS-Off Ver
    2016
    Posts
    24

    Delete two rows after offsetting first row

    I have multiple rows of data in a report. I only need the 1st, 4th, 7th, 10th ... etc row. The report starts at row 5.

    I've written some code but I'm having trouble selection multiple (2) rows after it is offset.

    How can I best do this?

    Please Login or Register  to view this content.
    Last edited by AlexJr; 01-27-2017 at 11:47 AM.

  2. #2
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,869

    Re: Delete two rows after offsetting first row

    Maybe :
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-08-2016
    Location
    Rotterdam, the Netherlands
    MS-Off Ver
    2016
    Posts
    24

    Re: Delete two rows after offsetting first row

    Adding resize was enough. Thanks!

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-08-2016
    Location
    Rotterdam, the Netherlands
    MS-Off Ver
    2016
    Posts
    24

    Re: Delete two rows after offsetting first row

    Adding resize was enough. Thanks!

    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,869

    Re: Delete two rows after offsetting first row

    You are welcome, don't forget to mark this thread as solved :
    select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. offsetting rows
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2015, 02:35 PM
  2. [SOLVED] Delete if older than 3 months and offsetting a cell input if match found
    By Templemind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2014, 07:25 AM
  3. Accounting - Macro to delete offsetting values
    By betrayedslinky in forum Excel General
    Replies: 1
    Last Post: 05-29-2014, 11:42 AM
  4. [SOLVED] Offsetting the Rows of a VLookup Result
    By Domenic in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Offsetting the Rows of a VLookup Result
    By John in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-13-2005, 12:05 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1